How to run.bat file via SSIS package

• premtg

  Say Hey Kid

  Points: 713

  More actions

  September 3, 2008 at 4:48 pm

  #197270

  I like to run the .bat file every 1/2 hr via SSIS package. Can you please help me how to write SSIS package for running .bat file? Thanks

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  September 4, 2008 at 7:04 am

  #867104

  I would just schedule a job executing xp_cmdshell.

  _____________________________________________________________________
  - Nate

  @nate_hughes

• premtg

  Say Hey Kid

  Points: 713

  More actions

  September 6, 2008 at 9:12 pm

  #868195

  Thanks for your idea. It save my time. Another method is just run the batch file in Job with cmdexc method.

• maruthi.vm

  SSC Rookie

  Points: 31

  More actions

  August 21, 2012 at 6:03 am

  #1528071

  Please post the code to run SSIS pacakges by using run.batch file and other way also.Thanks in advance

  --Maruthi

• kiril.lazarov.77

  Hall of Fame

  Points: 3742

  More actions

  August 22, 2012 at 8:00 am

  #1528649

  premtg (9/3/2008)

  ---

  I like to run the .bat file every 1/2 hr via SSIS package. Can you please help me how to write SSIS package for running .bat file? Thanks

  Use the execute process task.