Import SSIS package using DTUTIL

To import an SSIS dtsx package into SQL Server, use can use the DTUTIL utility with the following syntax:

dtutil /FILE <name>.dtsx /DESTSERVER SQLServer /COPY SQL;<name>

To import multiple SSIS dtsx packages into SQL Server, you can use a combination of the DTUTIL utility and the FOR batch command to load each dtsx file in a directory.

Execute the following command at a command prompt or from a command or batch file.

FOR %i In (*.dtsx) DO dtutil /FILE %i /DESTSERVER SQLServer /COPY SQL;DTSX_%~ni

This entry was written by Brian, posted on Thursday, February 25, 2010 Bookmark the permalink. Follow any comments here with the RSS feed for this post. You can post a comment.

Post a comment