SSIS Azure Storage Connection Manager Failed to Connect via SAS Key

%3CLINGO-SUB%20id%3D%22lingo-sub-3003544%22%20slang%3D%22en-US%22%3ESSIS%20Azure%20Storage%20Connection%20Manager%20Failed%20to%20Connect%20via%20SAS%20Key%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003544%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EWhen%20we%20use%20SSIS%20Azure%20Storage%20Connection%20Manager%20within%20SSIS%20to%20%22Test%20the%20Connection%22%20provided%20with%20a%20SAS%20key%2C%20It%20failed%20with%20invalid%20sasUri%20format.%26nbsp%3B%20Below%20is%20a%20sample%20sasUri%20key%20provided%20by%20the%20client.%26nbsp%3B%20What%20is%20the%20proper%20format%20of%20the%20sasUri%20for%20the%20token%3F%26nbsp%3B%20I%20am%20able%20to%20connect%20via%20Azure%20Storage%20Explorer%20with%20success.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20sample%20sasUri%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdemo2.blob.core.windows.net%2Fazurestorage%3Fsp%3Dr%26amp%3Bst%3D2021-11-24T22%3A27%3A15Z%26amp%3Bse%3D2023-01-01T06%3A27%3A15Z%26amp%3Bspr%3Dhttps%26amp%3Bsv%3D2020-08-04%26amp%3Bsr%3Dc%26amp%3Bsig%3DY6UfVbBLEBlXXc9cwwrrekJk1XlbLoFZKUK%252FID%252BeSnM%253D%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdemo2.blob.core.windows.net%2Fazurestorage%3Fsp%3Dr%26amp%3Bst%3D2021-11-24T22%3A27%3A15Z%26amp%3Bse%3D2023-01-01T06%3A27%3A15Z%26amp%3Bspr%3Dhttps%26amp%3Bsv%3D2020-08-04%26amp%3Bsr%3Dc%26amp%3Bsig%3DY6UfVbBLEBlXXc9cwwrrekJk1XlbLoFZKUK%252FID%252BeSnM%253D%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi,

When we use SSIS Azure Storage Connection Manager within SSIS to "Test the Connection" provided with a SAS key, It failed with invalid sasUri format.  Below is a sample sasUri key provided by the client.  What is the proper format of the sasUri for the token?  I am able to connect via Azure Storage Explorer with success.

 

Here is the sample sasUri:

https://demo2.blob.core.windows.net/azurestorage?sp=r&st=2021-11-24T22:27:15Z&se=2023-01-01T06:27:15...

 

0 Replies