2

I have an one data transfer package with .DTSX extension. I want to edit that package.

Please help me.

jarlh
  • 42,561
  • 8
  • 45
  • 63
Ragesh
  • 740
  • 3
  • 9
  • http://stackoverflow.com/questions/1829101/how-do-i-edit-ssis-package-files – massko Nov 07 '16 at 07:46
  • You can edit the XML in notepad, or if you know the version, you can edit it in Visual Studio (BIDS) or SQL Server Data Tools. Start by downloading SQL Server Data Tools – Nick.Mc Nov 07 '16 at 07:56
  • Open the file in notepad and look for the property `PackageFormatVersion`, you can determine what version of SSIS it was written for by that number. (Search online for translation.) –  Nov 07 '16 at 09:30

2 Answers2

3

DTS was the old extension name used for Integration Services packages. DTSX is new (I guess my new! refers to SQL2005)

With recent releases SQL Server introduced SQL Server Data Tools which is very similar to Visual Studio but concentrated on SQL Server tasks.

SQL Server Business Intelligence developers can use SQL Server Data Tools for creating and editing Analysis Services, Integration Services and Reporting Services solutions

enter image description here

Here is a download link

Eralper
  • 6,461
  • 2
  • 21
  • 27
0

Follow the following steps:

  1. Open BIDS or SSDT (it depends which version of sql server development tool you have installed)

  2. Create a new Sql Server Integration Project

  3. copy the .dtsx package by pressing Ctrl + c and go back to the newly created project , you will see the portion "Package" in Solution Explorer , Paste your copied package here by selecting the "Package" header.

  4. double click to this copied package, you can now edit your package.

Hadi
  • 36,233
  • 13
  • 65
  • 124
fahad
  • 154
  • 6