Issues utilizing Azure Files Connection Manager in SSIS

Alexander Cruz

unread,

Mar 14, 2025, 5:01:23 PMMar 14

to COZYROC

'm trying to generate a report using CozyRoc to retrieve the file containing my report data. I'm using a Rest Connection Manager configured with Azure File and Shared Key Authentication.

Everything works fine locally, but after deploying my DTSX package, the SSISDB job fails, stating that the Storage Account is not set. I'm attempting to set the storage account via expressions but can't find the corresponding property.

Has anyone successfully retrieved a file from Azure File Storage without running into these issues?

Ivan Peev

unread,

Mar 15, 2025, 9:37:33 AMMar 15

to COZYROC

Hi Alexander,

What do you have specified for package protection level?

Alexander Cruz

unread,

Mar 17, 2025, 10:44:12 AMMar 17

to COZYROC

I had to change the protection level on my solution to EncryptSensitiveWithUserKey so it's currently set to that. Is there an equivalent protection level configuration on server side ?

Alexander Cruz

unread,

Mar 17, 2025, 2:02:22 PMMar 17

to COZYROC

as stated by https://learn.microsoft.com/en-us/sql/integration-services/security/access-control-for-sensitive-data-in-packages?view=sql-server-ver16

I have set the protection level as encrypt sensitive data with a password and uploaded it but I'm still encountering the error.

Ivan Peev

unread,

Mar 18, 2025, 8:03:42 AMMar 18

to COZYROC

Alexander,

When deploying the package do you change the package protection level to "Use server storage protection" ?

Reply all

Reply to author

Forward