Running a DTS or SSIS package from a windows command line

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Running a DTS or SSIS package from a windows...

Running a DTS or SSIS package from a windows command line

Rate Topic

Display Mode

Topic Options

Author

Message

sek-1110234

Posted Tuesday, June 09, 2009 9:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 18, 2009 9:26 PM
Points: 6, Visits: 11

Can we run a dts or ssis package as an executable without having to use DTSRUN.exe or dtexec.exe from a windows command line?

Post #731604

Robbob

Posted Tuesday, June 09, 2009 11:35 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, June 13, 2013 10:56 AM
Points: 12, Visits: 206

No, I do not believe that you can run a package from a command line with out using the dtexec.exe executable file.

Post #731731

sek-1110234

Posted Tuesday, June 09, 2009 12:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 18, 2009 9:26 PM
Points: 6, Visits: 11

Thanks for your reply. So I guess the SQL Server SSIS or DTS package cannot run on a machine that do not have SQL Server software installed.

Post #731792

Robbob

Posted Tuesday, June 09, 2009 12:48 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, June 13, 2013 10:56 AM
Points: 12, Visits: 206

That has been my experience. You need the dtexec.exe program on the machine. Can you create the package for a machine that has the dtexec and connect to the other machine that doesn't have it for output or input?

Post #731796

RBarryYoung

Posted Tuesday, June 09, 2009 1:32 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

Hmm, couple of different things being asked here:

1) Packages are not actually independent executables, they are the input instructions to some other program that runs them like dtexec.exe or DTSRUN.exe.

2) You are not restricted to running them from the command line, DTSGUI can run SSIS packages from windows, both DTS and SSIs packages can be run from SQL Server or SQL Agent. However, all of these do go back to the command line executable to run them.

3) I cannot say about DTS, but SSIS packages can only run on machines with SSIS services installed. (VS/BIDS has a special SSIS install to handle local testing).

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #731819

sek-1110234

Posted Friday, June 12, 2009 7:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 18, 2009 9:26 PM
Points: 6, Visits: 11

Thanks so much for your info.

Post #733827

RBarryYoung

Posted Friday, June 12, 2009 8:28 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:17 AM
Points: 9,855, Visits: 9,376

Glad I could help.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #733906

« Prev Topic | Next Topic »

Permissions