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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply