March 25, 2013 at 12:34 pm
When I go into SSIS and look under the MSDB folder I can see the name of my package P1 but I want open it so I can make some modification to it. I know I can't open it I have to find where the .dtsx is stored on the server. But if I'm not mistaken it's not stored on the server (only if it was created as a file) correct, it's in the msdb database. The serve which the packages is running on doesn't have Visual Studio. My personal desktop does have VS, how can I view the package P1 ??
March 26, 2013 at 3:14 am
Hi kd11,
You can import the package from the server to a file using the dtutil utility.
Example1:
dtutil /SQL srcPackage /COPY FILE;c:\myTestPackages\mynewpackage.dtsx
Of course you can run this command direct from the command shell or using the Management Studio or other SQL client.
Example2:
EXEC [master].[sys].[xp_cmdshell] 'dtutil /Quiet /COPY SQL;"CreateLists" /SQL "CreateLists"
Here you can find the official documentation: dtutil Utility
and here an interesting article: Using dtutil to copy SSIS packages stored in SQL Server
Hope that helps.
Kind Regards,
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply