Run DTS Package from Command Line? Possible?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » Run DTS Package from Command Line? Possible?

Run DTS Package from Command Line? Possible?

Rate Topic

Display Mode

Topic Options

Author

Message

ahthomas

Posted Friday, August 17, 2012 8:52 AM

Valued 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

Matt Miller (#4)

Posted Friday, August 17, 2012 2:15 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:43 PM
Points: 6,998, Visits: 13,952

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 »

Permissions