locked
.Bat file to run ssis package RRS feed

  • Question

  • Hi all,

    I was wondering how i can create a .bat file which when double clicked on runs one or more SSIS packages. Can anybody tell me the syntax please??

    Thanks
    Saturday, March 7, 2009 1:34 PM

Answers

  • SSIS has the command line utility dtexec.  The below listed article outlines the syntax and use to execute a package using dtexec.  Create a .bat file using dtexec and the appropriate switches and this should serve your purpose.

    http://msdn.microsoft.com/en-us/library/ms162810.aspx

    David Dye
    • Proposed as answer by Todd McDermid Sunday, March 8, 2009 12:33 AM
    • Marked as answer by Bob Bojanic Thursday, March 12, 2009 5:11 PM
    Saturday, March 7, 2009 2:55 PM