CODEWITHSUNDEEP
sql-serverssis
Ragesh
Ragesh

Reputation: 738

SSIS package edit

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

Please help me.

Upvotes: 2

Views: 1560

Answers (2)

fahad
fahad

Reputation: 164

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.

Upvotes: 0

Eralper
Eralper

Reputation: 6612

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

Upvotes: 3

Related Questions