SSIS Error

Last post 09-01-2008 12:49 AM by dineshasanka. 2 replies.
Page 1 of 1 (3 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next

  • 08-07-2008 7:09 PM

    SSIS Error

    Reply Contact
    I am trying to export data from my production SQL box to Dev box and this is what i encounter:

    - Setting Source Connection (Error)
    Messages
    Error 0xc020801c: Source - AbAttribute [1]: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019.
    (SQL Server Import and Export Wizard)

    Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

    SQL 2005 Box with SP2 environment on prod and dev as well. Any input as to why this error is encounter?

    Many thanks,

     

    Cali

  • 08-31-2008 1:38 PM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 22,515
    • Microsoft MVP
      Moderator

    Re: SSIS Error

    Reply Contact

    This error often indicates a permissions problem with acquiring the connection. Does the user account you are using have access to the source data?

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.

  • 09-01-2008 12:49 AM In reply to

    Re: SSIS Error

    Reply Contact

     

    verify whether you can connect to sql server instance from sql server management studio
    Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com

    Visit my Blog at http://dineshasanka.spaces.live.com/

    View Dinesh Asanka's profile on LinkedIn
Page 1 of 1 (3 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.