Sign in
 
HomeLibraryWikiLearnGalleryDownloadsSupportForumsBlogs
Resources for IT Professionals >
> 
> 
> 
Test connection to SQL azure failed from SSIS package

Answered Test connection to SQL azure failed from SSIS package

  • Friday, June 01, 2012 7:28 AM
     
     
    Sign In to Vote
    0

    I got the following error while trying to connect a SQL Azure account from my SSIS package.

    Test connection failed because of an error in initializing provider

    The tracing ID of the session: f1e0103b-da86-4356-b7f6-12395c4bcdfe

    Please help me I am under extreme load as things going to live in day.

     

All Replies

  • Friday, June 01, 2012 10:29 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    If you were using OLEDB connection then You'll have to switch to ADO.Net - because as of now connecting to SQL Azure using OLE DB is not supported.

    Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )