Hi @Pat Snow ,
You need to go to Data Flow-->Azure Blob Source, and then you may configure the Azure storage connection manager like shown below.
Make sure that you have download the pack matches with your SQL Server version.
In addition, VS is a 32bit application, try to download the x86 version.
azure-feature-pack-for-integration-services-ssis
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
Which one do you use to connect to an azure sql server DB?
Hi @Pat Snow ,
Please refer to below:
https://www.mssqltips.com/sqlservertip/5514/using-azure-storage-and-azure-sql-database-for-ssis-development/
Sign in to comment