CODEWITHSUNDEEP
visual-studio-2012deploymentparametersssis
bobetko
bobetko

Reputation: 5168

SSIS project parameters can't be found when package deployed

When I deploy package to test server, all parameters that are in project scope are not available. (they are all in project.params) file.

Here is how we deploy and run packages? Prior SSIS 2012, I would have xxx.dtsx and xxx.dtsConfig in folder, then we would have script that uses DTEXEC tool to execute package. Our scheduling tool runs jobs/script hourly, daily, monthly, etc...

Now, with SSIS 2012, they got away with configuration and introduced parameters. Now in my package deployment folder, I have only xxx.dtsx and project.params files. Project.params file contains all variables that I decided to parametrize. While this work nicely when debugging in VS2012, once deployed, it doesn't work at all.

Any advice on what to do here?

Thanks

Upvotes: 0

Views: 3992

Answers (1)

billinkc
billinkc

Reputation: 61201

For non-project based connections, when you run the package, it'd take a form like

dtexec /file MyPackage.dtsx

However, for project based connections, you need to include the project (.ispac) in the dtexec call. Otherwise, you'll end up with missing connection or project parameter errors

dtexec /package MyPackage.dtsx /project MyProject.ispac

Upvotes: 1

Related Questions