September 17, 2021 at 2:54 pm
Hi Guys,
Is there a way to save the Blob Storage Key into a package/project so that it doesn't need to be modifed after deployment each time?
cheers
Alex
September 17, 2021 at 2:58 pm
Hi Guys,
Is there a way to save the Blob Storage Key into a package/project so that it doesn't need to be modifed after deployment each time?
cheers
Alex
Excuse my ignorance, but what is that? Whatever it is, I don't have to modify if every time after deployment.
September 21, 2021 at 8:56 am
Pardon my slow reply.
The storage key is used to autenticate the SSIS Azure Components with the Storage Accout. We have files (text files, csv, etc) on these accounts which we use SSIS to import into SQL Server (on-prem, hilariously) but to do the the key needs to put into the connection in the package.
September 21, 2021 at 9:05 am
Pardon my slow reply.
The storage key is used to autenticate the SSIS Azure Components with the Storage Accout. We have files (text files, csv, etc) on these accounts which we use SSIS to import into SQL Server (on-prem, hilariously) but to do the the key needs to put into the connection in the package.
OK, then the answer is yes.
Assuming you are deploying your packages to SSISDB, you can create a storage key parameter in your package and pass its value as an SSISDB environment variable. If/when the value of the storage key changes, all you need to do is modify the environment variable.
More about parameters here.
More about SSISDB variables here.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy