Post reply

SSIS Package

  • January 16, 2014 at 11:03 am

    #303247

    Hello,

    I have created SSIS Package file which I am trying to run via .bat file so I can schedule it to run at specific time. I am able to call DTExecui.exe and the .dtsx file but I need to click "Execute" button manually. Here is the code I am using in .bat file.

    "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\DTExecUI.exe" /FILE "C:\file.dtsx" /MAXCONCURRENT " 1 " /CHECKPOINTING OFF /REPORTING EW /CONSOLELOG T

    Any help would be greatly appreciated.

    Thanks,

    Yash

  • January 16, 2014 at 11:07 am

    #1680784

    You're using DTExecUI (User Interface), which is why.

    What you want is plain old DTExec:

    http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

    By the by, why not just use a job and the SSIS step in SQL Agent?

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • January 16, 2014 at 11:19 am

    #1680796

    Perfect, this saved me lot of time and energy. Much Appreciated.

    Thanks,

    Yash

  • January 16, 2014 at 11:22 am

    #1680798

    yashuvp (1/16/2014)

    Perfect, this saved me lot of time and energy. Much Appreciated.

    Thanks,

    Yash

    My pleasure, glad I could help.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

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

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