Can I deploy an SSIS package to the file system using DTUTIL?
I have an SSIS package named Extract.dtsx. I want to deploy it to the filesystem at F: \ SQL2005 \ MSSQL \ Package \ Extract.
The package installation wizard makes this easy. I only need to select "Deploy filesystem" and select the path, then click a few times and finish. I am having trouble figuring out if I can do the same with DTUTIL.
Does anyone know if this is possible?
a source to share
Yes it is possible. I'm not sure what I was doing wrong.
If you have the SSIS package C: \ temp \ Extract.dtsx, you can deploy it to the file system at F: \ SQL2005 \ MSSQL \ Package \ Extract using the following commands:
c:\temp\md F:\sql2005\mssql\package\Extract
c:\temp\dtutil /file Extract.dtsx /Copy FILE;F:\sql2005\mssql\package\Extract\Extract.dtsx
The target folder must already exist.
You can see the package in SQL Enterprise Manager by connecting to SSIS on the server, open Stored Packages> SSIS Application Packages> Extract.
a source to share