Content

• Video Tutorial
• Step-By-Step
• Component Properties
• Error Handling
• Settings UI
• See also

Video Tutorial

1. In order to connect to Azure Storage Service from SSIS you will need Storage Account Name and Access Key. Ask your SysAdmin or responsible person to provide that information to you. Here is sample Account Name and Access Key(this is just example key which may differ in your case)

   Account Name: mystorageaccount
   Access Key: Eby8vdM02xNOcqFlqUwJPLlmEtlCDXJ1OUzFT50uSRZ6IFsuFq2UVErCz4I6tq/K1SZFPTOtr/KBHBeksoGMGw==

   
   Microsoft also provides offline simulator to test Azure Storage functionality (Blob, Table, Queue). This is great way to try out Azure Storage functionality without worrying about Cost but we strongly recommend you to test everything with Azure Cloud Account before going to Production. Click here to read more how to get your Storage Account Name and Access Key

   
   If you don't have Azure Storage account then its easy to get Trial Azure Storage account or use your MSDN to get credit each month which will be more than enough for real testing. If you prefer to avoid all this hassle then Microsoft provides another great way to test Azure Storage functionality in totally offline mode on your local machine. You can just download Azure Storage Emulator and start testing. Click here to learn more how to configure Azure Storage Emulator for Testing and Development purpose.

2. Once you have Account Name (its like UserID) and Access Key (its like password) you may proceed to create new SSIS package. In BIDS/SSDT create new SSIS package
3. For this sample exercise we will need new Azure Storage Table. To create new Table perform following steps
   • first make sure you have valid azure cloud account or get local storage emulator for testing Click on create table under Azure Storage
   • Connect to Azure Storage Account using your favourite client tool and create new Azure Queue Storage (Call it zappysystest for this demo). We used FREE tool called Microsoft Azure Storage Explorer
     
4. From the SSIS toolbox drag and drop Data Flow Task on the controlflow designer surface.
5. Double click on the Data Flow task to see Data Flow designer surface.
6. Right Click in Connection Manager Panel and select [New Connection...] menu item. Pick ZA-AZURE-STORAGE connection type. Enter AccessKey, SecrentKey or Use Developer Account if you using local emulator. Click Test connection to verify credentials.
   
   
   
7. Click OK to save connection information.
8. From the SSIS toolbox drag and drop Dummy Data Source on the dataflow designer surface.
9. Double click Dummy Data Source to configure it.
10. From Template pick JsonDocuments and enter row count=100 to generate 100 json documents and click OK to save
    
11. From the SSIS toolbox drag and drop Azure Queue Storage Destination on the dataflow designer surface.
12. Now single click on the Dummy Data Source, once you see blue arrow from source ... connect it to Azure Queue Destination.
13. Now double click Azure Queue Storage Destination to configure it.
14. On [Connection Manager] tab select Azure Queue connection manager.
    
15. Click on [Component Properties] tab and select Target Queue from dropdown list.
    
16. Click on [Mappings] tab and verify mapping. Map Document column from upstream to MessageText target column.
    
17. Click OK to save settings.
18. Execute the package and verify target data by going to your Azure Queue (We used FREE tool called Microsoft Azure Storage Explorer ).
    
    

• SSIS Azure Queue Storage Source Adapter
• SSIS Azure Queue Storage Destination Adapter
• SSIS Azure Storage Connection Manager