how to deploy ssis package and execute package using command line ?

Posted by Chamu under Sql Server on 8/13/2016 | Points: 10 | Views : 310 | Status : [Member] | Replies : 2
how to deploy ssis package and execute package using command line ?




Responses

Posted by: A2H on: 8/14/2016 [Member] [MVP] Silver | Points: 25

Up
0
Down
SQL Server includes the command line tool DTEXEC.EXE which can be used to execute an SSIS package. DTEXEC can be run from a Command Prompt or from a batch (.BAT) file.


To execute an SSIS package that is saved in the file system, use the following code:
dtexec /f "c:\TestFolder\SampleSSISPackage.dtsx" 



Reference Links
https://msdn.microsoft.com/en-us/library/ms162810.aspx
https://www.mssqltips.com/sqlservertutorial/218/command-line-tool-to-execute-ssis-packages/


Thanks,
A2H
My Blog

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajnilari2015 on: 8/15/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
Please read https://www.mssqltips.com/sqlservertutorial/213/deploying-ssis-packages/

Let us know in case you have any doubt.

--
Thanks & Regards,
RNA Team

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response