locked
Executing SSIS Package using .bat file RRS feed

  • Question

  • Hi Guys,

    Please I need some assistance, I know we can executing a package using a batch file if the ssis package is in our local file system. I will like to find out if we can do this for a package deployed to Integration Services Catalogs.

    Thanks


    me

    Friday, November 23, 2018 3:18 PM

Answers

  • Hi lilutchay,

    The dtexec.exe command prompt utility is used to configure and execute SQL Server Integration Services packages. To run packages that are deployed to the Integration Services server using the project deployment model, use the /ISServer option.

    For example:

    Dtexec /isserver “SSISDB\MyFolder\MyProject\MyPackage.dtsx” /server “.”

    Full documentation is here:

    dtexec Utility

    • Proposed as answer by Yang.Z Monday, November 26, 2018 7:51 AM
    • Marked as answer by lilutchay Wednesday, December 12, 2018 9:06 PM
    Sunday, November 25, 2018 3:10 AM
  • You can use dtexec itself to execute package which is in catalog

    For that dtexec command would look like

    DTExec /ISSERVER "\SSISDB\<full folder path>\Package.dtsx" /SERVER "<servername>" /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb /Par "$ServerOption::SYNCHRONIZED(Boolean)";True  

    /Par represents various parameters for which you need to pass values

    see other examples here

    https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-2017


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Sunday, November 25, 2018 6:07 AM
    • Marked as answer by lilutchay Wednesday, December 12, 2018 9:06 PM
    Sunday, November 25, 2018 6:06 AM

All replies

  • Hi lilutchay,

    The dtexec.exe command prompt utility is used to configure and execute SQL Server Integration Services packages. To run packages that are deployed to the Integration Services server using the project deployment model, use the /ISServer option.

    For example:

    Dtexec /isserver “SSISDB\MyFolder\MyProject\MyPackage.dtsx” /server “.”

    Full documentation is here:

    dtexec Utility

    • Proposed as answer by Yang.Z Monday, November 26, 2018 7:51 AM
    • Marked as answer by lilutchay Wednesday, December 12, 2018 9:06 PM
    Sunday, November 25, 2018 3:10 AM
  • You can use dtexec itself to execute package which is in catalog

    For that dtexec command would look like

    DTExec /ISSERVER "\SSISDB\<full folder path>\Package.dtsx" /SERVER "<servername>" /Envreference 2 /Par "$Project::ProjectParameter(Int32)";1 /Par "Parameter(Int32)";21 /Par "CM.sqlcldb2.SSIS_repro.InitialCatalog";ssisdb /Par "$ServerOption::SYNCHRONIZED(Boolean)";True  

    /Par represents various parameters for which you need to pass values

    see other examples here

    https://docs.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-2017


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Sunday, November 25, 2018 6:07 AM
    • Marked as answer by lilutchay Wednesday, December 12, 2018 9:06 PM
    Sunday, November 25, 2018 6:06 AM