Author: Mukesh Bhatt, 15 November 2017
I have a csv file
in Azure Blob Storage and I want to import to my local SQL Server and in a csv
we will use the S
QL Server Integration
named Azure Blob Source, which is installed with the Feature Pack for SSIS to
connect to Azure.
1. Create a text
file name Product_data.txt with the following content in the Sample
ProductCode,ShippingWeight,ShippingLength,ShippingWidth,ShippingHeight,UnitCost,PerOrder 13496967,75.700000000000003,1.78,5.1100000000000003,8.8200000000000003,86.670000000000002,8 30223445,66.5,4.2800000000000002,5.8200000000000003,6.9000000000000004,52.030000000000001,3
2. Using MASE, upload
the file of step 1 to the Azure Blob container myblobtestazure.
3. Using SSDT,
create a SSIS project. Drag and drop a Data Flow Task to the design pane:
4. Double click Data Flow. Drag and drop Azure
Blob Source. This is a new task included in the SSIS Feature Pack for Azure
installed as part of the prerequisites. This task will be used to connect to
the csv file in Azure:
Double click Azure Blob Source and fill the
5. Drag and drop a Flat File Destination and join this task with the
Azure Blob Source:
Double click Flat File Destination and fill the
required information along with Mappings tab to map source columns with
6.As same we can make the connection from Azure portal to SQL server on
Premise, but we need to use for that multicast to distribute the data for both
7. Start the package to copy the Azure information
from the csv file to local server and sql database table. To view the data
runtime, we can enable the data viewer in multicast toll.
8. Here is
multicasting output in runtime to view the data flow and data.
everything is OK, a new file will be created in the path specified and table
loaded in the database.