question

Papillon28-9167 avatar image
0 Votes"
Papillon28-9167 asked YitzhakKhabinsky-0887 edited

SSIS failed when using Sensitive Check for password in Environment property

Hi All,

I am having issue when I run the package with Don't Save Sensitive property On and password in environment variable checked as Sensitive. When run through job it is failing but when I put hardcoded password then it works fine.

Please help me out.

  • Project parameter **

119151-image.png


Environment Variable after deployment
119152-image.png

Environment Variable property -- if I use hard coded value here then it works fine..
119142-image.png




T.I.A

sql-server-integration-services
image.png (4.8 KiB)
image.png (38.3 KiB)
image.png (22.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited

Hi @Papillon28-9167,

There are peculiarities while working with Sensitive parameters.

The best way to handle it is by copying the sensitive parameter value to a (non-sensitive) variable value using a Script Task.

It is described pretty well here: using-sensitive-parameters-ssis-series


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.