How to execute SSIS package from command or any other utility without using SSMS?

• bndgyawali

  SSC-Addicted

  Points: 413

  More actions

  April 8, 2010 at 5:16 am

  #217540

  Hello Frens,

  I have created a SSIS project and deployed it too. My project contains list of procedures to be run parallelly. This project needs only one connection to my database. So, I have created only one Connection Manager.

  I tried the method of "save the copy of project as" and saved in file as well as sql server.

  And the method of "deployment using menifest file" too. I think these two methods equivalent. Am i right??

  Now, I want to run this deployed dtsx package to run from command line or any other utility providing my connection details externally. Please help me to solve the problem.

  Thanks in advance

• DNA_DBA

  SSCrazy Eights

  Points: 9132

  More actions

  April 8, 2010 at 5:27 am

  #1148144

  Do a search for the dtexec utility in Books Online

• bndgyawali

  SSC-Addicted

  Points: 413

  More actions

  April 8, 2010 at 5:59 am

  #1148162

  I found command dtexec /conn connectionfilename packagename.dtsx to execute my package by providing external connection.

  But can you please help me to prepare connectionfile. I can't find anywhere googling the syntax of the connectionfile.

  Please help me