We can choose ‘localhost’ if running this within the server as shown in the below figure.Īs seen in the above figure all our packages are imported into the server.įor more dtutil Utility options please see the MSDN article HERE. Change the server name at the end of the code to reflect the destination server.Change the package folder location where the SSIS packages will be deployed.Note to make the below changed before you run the above script. Tip: Hold ‘Shift’ and right click to open command prompt window at the desired location.įor %I in (*.dtsx) do dtutil /FILE "%I" /COPY SQL "/Packages/%~nI" /DESTSERVER localhost Open command prompt where the packages (.dtsx) are stored In this article we will see deploying multiple SSIS packages.ġ. How to Copy or Export an SSIS Package Using Command Prompt Utility – DTUTIL It is capable of importing and exporting packages and is found in the Binn folder of SQL Server (For eg: C:\Program Files\Microsoft SQL Server\110\DTS\Binn\dtutil.exe)īelow is a post from Suresh, which describes how dtutil works for importing and exporting one package at a time. It utilizes the “dtutil.exe” application which is installed by default with SQL Server installation. Though there are several ways for importing SSIS packages into SQL Server either by creating a stored procedure or using a SSIS package itself, I find this simple code of line much easier and handy to work with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |