This post is to show you want to use SSIS with full Azure environment, SQL Azure database and Azure Blob Storage. The pre-requisites to this article are; 1, Visual Studio 2017 and above. 2. You need to be familiar with SSIS basic. 3. You need to know how to create SQL Azure database, and lastly 4. You need to know how to create Azure Blob Storage.
1. Create a SQL Azure connection using OLEDB connection. You can get the server name from Azure portal if you cannot remember the server name.
2. Create an Azure Storage connection. Get the access key from Azure portal then insert into SSIS Azure Storage Connection Manager Editoer.
3. Drag a Data Flow Task onto Control Flow pane. Double click the Data Flow Task.
4. Drag a OLE DB Source and Azure Data Destination and connect them.
5. Double click the OLD DB Source to configure the data source. I duplicated the Products table in Northwind database as ProductsTemp table.
I6. Double click the Azure Data Destination to configure a text file.
You can now extract the data from SQL Azure Database and output it to a text file.