How to run.bat file via SSIS package

Question

Post reply

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

RP_DBA SSCertifiable Points: 5116 More actions · Answer 1

I would just schedule a job executing xp_cmdshell.

_____________________________________________________________________
- Nate

@nate_hughes

premtg Say Hey Kid Points: 713 More actions · Answer 2

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 · Answer 3

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 · Answer 4

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.