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.
It helps...IS there any switch to the command so that we can inject config file also....
ReplyDeleteVery nice article,Keep updating more posts.
ReplyDeleteThank you...
MSBI Training
Thank you for sharing wonderful information with us to get some idea about that content.
ReplyDeleteMsbi Developer Course
Best Msbi Online Training