Post reply

Running a DTS or SSIS package from a windows command line

  • June 9, 2009 at 9:59 am

    #132746

    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?

  • June 9, 2009 at 11:35 am

    #1006942

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

  • June 9, 2009 at 12:41 pm

    #1006998

    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.

  • June 9, 2009 at 12:48 pm

    #1007001

    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?

  • June 9, 2009 at 1:32 pm

    #1007020

    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).

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • June 12, 2009 at 7:39 am

    #1008633

    Thanks so much for your info.

  • June 12, 2009 at 8:28 am

    #1008702

    Glad I could help.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply