Executing SSIS Package using .bat file

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

Answer 1

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

Answer 2

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