CODEWITHSUNDEEP
ssisssis-2012
user1902849
user1902849

Reputation: 1141

SSIS dynamic connectiong string via environment variable failed to execute

I want to test dynamic connection string in SSIS. Here were the steps that I already performed.

1) Created connection string.
2) Parameterizing connection string
3) Deploy SSIS Package to SSIS Catalog via Project deployment model
4) Setup environment variable in SSIS Catalog
5) Configure SSIS project to reference environment variable

Everything look goods but failed to execute the task.

SSIS Catalog

SSIS Catalog

Project configuration

enter image description here

Error message

enter image description here

enter image description here

Upvotes: 2

Views: 442

Answers (2)

Celia
Celia

Reputation: 21

I think you should fix the issue with the steps below:

  1. Create a Proxy account with permissions in SSISDB and the permissions needed for the db used in the package.
  2. Create a credential in the SSIS server. The user and password are the same that the proxy account.
  3. Use the proxy account to execute the project.

Upvotes: 1

Gaurav Singh
Gaurav Singh

Reputation: 16

As per the screenshot, it looks like the package is failing due to login issue. Please check the login with which the package is running and it has correct access to DB Server.

Upvotes: 0

Related Questions