How to Fetch files stored in azure container using SSIS – Execute process task

Home Page Forums FAQs – SSIS Tips and Tricks How to Fetch files stored in azure container using SSIS – Execute process task

This topic contains 0 replies, has 1 voice, and was last updated by  ZappySys 5 years, 11 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #687

    ZappySys
    Keymaster

    If you want to bring Azure Blob to local machine using FREE Command line utility then here is simple trick

    1. First download XCopy version of FREE Command line for Azure
    2. Extract files to C:\Utilities (or your own place)
    3. Create new SSIS Package and drag Execute Process Task on designer surface
    4. Double click task and set properties as below. Basically you will have to use following command

    blob get "azuretest/*.csv" "c:\azure" -y --accesskey YourAzureStorageAccountName --secretkey your_api_key

    [caption id="" align="alignnone" width="643"]How to fetch Azure Blob to local machine using SSIS Execute Process Task How to fetch Azure Blob to local machine using SSIS Execute Process Task[/caption]

Viewing 1 post (of 1 total)

The forum ‘FAQs – SSIS Tips and Tricks’ is closed to new topics and replies.