Execute SSIS package containing project parameters from command prompt

Question

Execute SSIS package containing project parameters from command prompt

venkatesh padmanabhan 181

Hi.
How to run SSIS Packages, which contains package parameters through command prompt ?

Accepted answer

2 additional answers

Your answer

Answer 1

Hi @venkatesh padmanabhan ,

1.If the package is stored in the file system, please run the following command:

DTEXEC /Project c:\project.ispac /Package Package1.dtsx /SET \Package.Variables[$Package::Parameter];1 /SET \Package.Variables[$Project::Parameter];1

2.If the package is stored in the SSISDB Catalog, please run the following command:

DTEXEC /Server localhost /ISServer "\SSISDB\MyFolder\Integration Services Project1\Package.dtsx" /Par "$Project::ProjectParameter(Int32)";1 /Par "CM.SourceServer.InitialCatalog";SourceDB

Best Regards,
Mona

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Vaibhav Chaudhari 38,921 Volunteer Moderator

See if examples given in below helps

https://learn.microsoft.com/en-us/sql/integration-services/packages/dtexec-utility?view=sql-server-ver15#example

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 3

Guoxiong 8,206

Take a look at this thread: Is it possible to pass parameters to a .dtsx package on the command line?

Share via

Execute SSIS package containing project parameters from command prompt

2 additional answers

Your answer