Post reply

Command line to run ssis

  • February 15, 2012 at 5:12 pm

    #253105

    We have scripts that setup by someone else that is to run command line file to call ssis package.

    I would like to know how this commandline file generated?

    It doesn't look like it was written manually line by line, it must be generated from somewhere?

    See attached script.

    I change the file extension from cmd to .txt so that you can open it.

    Thanks

  • February 15, 2012 at 5:58 pm

    #1447619

    Hi,

    the file may well have been written manually.

    It's just calling a single package and setting some variables and other options.

    More likely though the package call itself was copied from DTExecUI.exe.

    This is the interface provided to you when you are scheduling a package in SQL Server Agent,

    or it can be accessed directly here (in a standard installation):

    'C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\DTexecUI.exe'

    This executable allows you in a GUI format to set the options and variable values that you require, then click to

    execute a package on demand or else go to the command line tab and you can copy the text into a batch file for example.

    HTH,

    Sam

  • February 15, 2012 at 11:56 pm

    #1447672

    If you know a little bit about batch programming, than the file is pretty easy to write.

    Here you can find the details about the DTEXEC utility, along with it's parameters:

    dtexec Utility (SSIS Tool)

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 16, 2012 at 11:46 am

    #1448066

    Thank you all, I do see the person today, I asked her she wrote it manually.

    I thought it is a pain to do that esp.with some parameters.

    good to know the DTExe utility can do part of the job.

Viewing 4 posts - 1 through 3 (of 3 total)

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