I have a a project with multiple packages under the SSIS_Packages folder. Can i deploy one of those package instead of the project? The documentation here indicates to use .SSISDeploymentManifest. I don't want to deploy all the packages under the project, just one to SQL Server 2005.
A:
Easies would be to create a new SSIS project in VStudio containing only the desired package and deploy this single package.
Henrik
2009-08-13 06:57:37
This is what I've been doing but this is not the way.
Saif Khan
2009-08-14 15:31:06
+1
A:
Check the dtutil utility out (following sample taken from here) :
dtutil /DestS [servername] /FILE [filename].dtsx /COPY SQL;[foldername]\[filename]
Mac
2009-08-13 07:21:20