locked
Connecting to AZURE Storage Tables RRS feed

  • Question

  • 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!


    lekfir
    Tuesday, January 25, 2011 12:17 PM

Answers

  • 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
    Tuesday, January 25, 2011 1:55 PM

All replies

  • 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


    DBA, Datacruncher and Boardgamer
    Tuesday, January 25, 2011 12:30 PM
  • Thanks,

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

    Any help?

     


    lekfir
    Tuesday, January 25, 2011 1:15 PM
  • 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?

    Tuesday, January 25, 2011 1:35 PM
  • Thanks for your quick replay.

    I am looking to download whole tables data...

     


    lekfir
    Tuesday, January 25, 2011 1:47 PM
  • 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
    Tuesday, January 25, 2011 1:55 PM