SQL Server Integration Services Package

[747576]

Hi,
I have a scheduled job setup on a server, which has a step to transfer data from one serevr to another. The step is a package. Ho do I open and view this package to see what it does and modify it?
Thanks

 

[TonyKhela]

Hi,

Open up Visual Studio, start a new project/solution, with SSIS as type.

Then right click, SSIS Packages and choose 'add existing package'.

Navigate to the .dtsx file and add it.

You can modify it.

Hope it helps.

Regards
TK