Execute SSIS package through Batch file

• parul2j

  SSC Veteran

  Points: 255

  More actions

  March 16, 2011 at 5:06 pm

  #236420

  Hi All,

  I have requirement to run the SSIS through batch file and have to do the export from file to database(for 3 diff tables).

  -Can i get the sample batch file that could be run on server to execute the package?

  - Also wat could be the best way to implement it either single .dtsx package(for 3 diff tables) or 3 different dtsx package that could be run through the batch file?

  Please provide your inputs in regards to the same.

  Thanks

  Parul

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  March 17, 2011 at 4:52 am

  #1299859

  Double post, no replies please.

  Original thread with replies can be found here:

  http://www.sqlservercentral.com/Forums/Topic1079388-148-1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP