SQL Server Performance

SSIS Error

Discussion in 'SQL Server 2005 Integration Services' started by california6, Aug 7, 2008.

  1. california6 New Member

    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,
    california6, Aug 7, 2008
    #2

  2. satya Moderator

    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, Aug 31, 2008
    #3

  3. dineshasanka Moderator

    verify whether you can connect to sql server instance from sql server management studio
    dineshasanka, Aug 31, 2008
    #4

Share This Page