Execute Package Utility | Pass project parameters on Set Values tab

MariaBD 116 Reputation points
2020-12-04T18:06:42.26+00:00

Hi folks,

I have configured a package on Execute Package Utility on SQL Management Studio. I was able to pass new values of variables through Set Value tab. Now, I need a pass a diferente value for a parameter (that was defined on project level during development). I tried to use "\Project.Variables[Parameter_Name].Value" but it's not working.

45332-screen-shot-2020-12-04-at-145743-2.png

45293-screen-shot-2020-12-04-at-145828-2.png

45294-screen-shot-2020-12-04-at-145800-2.png

Any idea?

Thanks,

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MariaBD 116 Reputation points
    2020-12-05T12:24:38.713+00:00

    Hi @Yitzhak Khabinsky ,

    My SSIS version is 2016. Unfortunately, by company policy, we only have access to the DTSX but not to the solution folder.

    Regards,

    0 comments No comments

  2. Monalv-MSFT 5,891 Reputation points
    2020-12-07T05:37:55.487+00:00

    Hi @MariaBD ,

    dtexec /Project "C:\Test\SSIS\C\2020\Pro\Integration Services Project4\bin\Development\Integration Services Project4.ispac" /Package Package.dtsx  /SET \Package.Variables[$Project::DatabaseName];"MyDB1"  
    

    We should get the project folder if we want to execute the ssis package with project parameter using command.

    Please refer to the following link and pictures:

    dtexec Utility /Set

    45641-commandline.png

    45642-cmd.png

    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.
    Hot issues in November--What can I do if my transaction log is full?
    Hot issues in November--How to convert Profiler trace into a SQL Server table?