Hi,

I am trying to connect to AZURE Storage tables using SSIS.

Is it possible?

What is the Data flow source?

Which Provider to select?

Any guide?

Thanks!

Some information on this at:

 

http://www.sqlazuretutorial.com/2010/introduction-to-sql-azure/

 

You need to use the ADO.Net connection object for Azure and credentials similar to:

 

http://www.azuresupport.com/wp-content/images_misc/sql_azure_intro_files/image011.png

Thanks,

But I am want to use SSIS to connect and download data from AZURE Storage tables and not AZURE SQL...

Any help?

 

Apologies... I read your question too quickly.

Not sure how easy this is currently due to the difference in the types of data here. SSIS is used to the set-based tables with columns and rows whereas AST are built differently.

Not sure if there is much in the way of support for this in SSIS yet as the commands used are all part of a REST API. .Net CLR may be one way to go. Web service task may also be used in SSIS but this looks like it could be a bit cludgy depending on the sort of querying you are doing.

 

Are you carrying out simple queries or trying to get a full download of the data?

Thanks for your quick replay.

I am looking to download whole tables data...

 

didn't think it was possible as there aren't any components in SSIS that handle this sort of source. There are some videos online though that deal with creating custom components:

http://wn.com/rainerstropek

There is also a Microsoft tool that lets you brows/download all your data manually:

http://blogs.msdn.com/b/architectsrule/archive/2010/02/15/windows-azure-storage-browser.aspx

 

Sorry to not be of more help..

• Marked as answer by lekfir Wednesday, January 26, 2011 9:40 PM

Hi,

We are pleased to announce high quality commercial Adapters for Azure Table Storage. We are working hard to bring many more connectors for SSIS users.

	Azure Table Storage Source	Fast data extract from Azure Table Storage. Support for SQL query language (Proprietary parsing engine translates SQL query into Azure Table query). Read more
	Azure Table Storage Destination	Bulk insert data to Azure Table Storage. Option to define batch size for efficient data insert. Read more