Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to run.bat file via SSIS package Expand / Collapse
Author
Message
Posted Wednesday, September 3, 2008 4:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 4, 2008 7:04 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 7:13 AM
Points: 620, Visits: 864
I would just schedule a job executing xp_cmdshell.


_____________________________________________________________________
- Nate

@nate_hughes
Post #563770
Posted Saturday, September 6, 2008 9:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 25, 2013 11:38 AM
Points: 3, Visits: 139
Please post the code to run SSIS pacakges by using run.batch file and other way also.Thanks in advance
--Maruthi
Post #1347733
Posted Wednesday, August 22, 2012 8:00 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 4:59 PM
Points: 275, Visits: 1,665
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse