How to run.bat file via SSIS package

Home

Author

Message

Posted Wednesday, September 03, 2008 4:48 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, July 25, 2009 10:51 PM
Points: 13, Visits: 19

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

Post #563476

Posted Thursday, September 04, 2008 7:04 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:31 PM
Points: 580, Visits: 814

I would just schedule a job executing xp_cmdshell.

_____________________________________________________________________
- Nate

@nate_hughes

Post #563770

Posted Saturday, September 06, 2008 9:12 PM

Grasshopper

Group: General Forum Members
Last Login: Saturday, July 25, 2009 10:51 PM
Points: 13, Visits: 19

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

Post #565093

Posted Tuesday, August 21, 2012 6:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 7:20 AM
Points: 3, Visits: 136

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

--Maruthi

Post #1347733

Posted Wednesday, August 22, 2012 8:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 9:35 AM
Points: 237, Visits: 1,216

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.

Post #1348419

Permissions