Execute SSIS package containing project parameters from command prompt

venkatesh padmanabhan 181 Reputation points
2020-10-01T14:32:07.703+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
SQL Server | Other
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,926 Reputation points
    2020-10-02T01:33:15.357+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,921 Reputation points Volunteer Moderator
    2020-10-01T14:42:29.523+00:00

    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

    1 person found this answer helpful.
    0 comments No comments

  2. Guoxiong 8,206 Reputation points
    2020-10-01T16:03:22.567+00:00
    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.