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

Run DTS Package from Command Line? Possible? Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 8:52 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 30, 2013 7:19 PM
Points: 50, Visits: 66
How does one run a dts package from the command line? We have a few packages not running from the SQL agent, and our app dev on call folks are not allowed to touch production packages, putting a batch file in between them and the package fixes this. So how do I run a batch file via CLI?
Post #1346597
Posted Friday, August 17, 2012 2:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:12 PM
Points: 7,084, Visits: 14,685
create a batch using the exec utility.

http://msdn.microsoft.com/en-us/library/ms138023.aspx


----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #1346744
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse