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

Running a DTS or SSIS package from a windows command line Expand / Collapse
Author
Message
Posted Tuesday, June 9, 2009 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 9, 2009 11:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:59 AM
Points: 12, Visits: 207
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
Posted Tuesday, June 9, 2009 12:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 9, 2009 12:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:59 AM
Points: 12, Visits: 207
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
Posted Tuesday, June 9, 2009 1:32 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:52 AM
Points: 9,294, Visits: 9,495
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
Posted Friday, June 12, 2009 7:39 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, June 12, 2009 8:28 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:52 AM
Points: 9,294, Visits: 9,495
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 »

Add to briefcase

Permissions Expand / Collapse