Deploy SSIS Package by using Command line
Introduction:
Description:
• First we create the package with the name Sample1.dtsx at d:\ssis\ location.
• Open a command prompt and navigate the ssis project folder as shown below.
• In this example that follows, I will explain how to deploy the Sample1.dtsx package to the FileSystem and SQL Server.
• To deploy the package to the file system by using DTUTIL command as follows.
à Execute DTUYIL Command at Command line as shown below.
• To deploy the package to the SQL Server by using DTUTIL command as follows.
Introduction:
SQL Server introduces the command line tool DTUTIL.EXE; it is used to manage SSIS packages. The tool can copy, move, delete, or verify the existence of a package and it is a good choice when you want to script out the deployment of SSIS Packages.
• First we create the package with the name Sample1.dtsx at d:\ssis\ location.
• Open a command prompt and navigate the ssis project folder as shown below.
• In this example that follows, I will explain how to deploy the Sample1.dtsx package to the FileSystem and SQL Server.
• To deploy the package to the file system by using DTUTIL command as follows.
• To deploy the package to the SQL Server by using DTUTIL command as follows.
à Before and After position of packages at Integration Services in SQL Server.
Note: The above command deploys to the default SQL Server instance on the local machine.
Let me know what you think about this Article.
