requirement is to load the file from blob storage i.e., container to the MS SQL server Table. I had created a package with connection manager of Azure storage connection manager editor and I m using Service Principal and also using managedIdentity for the Authentication, the package is running successfully when I pass the inputs such as token and account name directly in the connection manager. if I pass the inputs in the expressions of the conntion manager then it is showing the below error – ” please construct the sasuri in format of storageuri?sastoken in ssis ” in the package execution log.

https://i.sstatic.net/A2Wce2T8.png
https://i.sstatic.net/8MGA3lET.png

I m calling the values from the table using execute sql task

I m not sure y this error is coming only when I pass the values from the expression