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,
  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?
  3. dineshasanka Moderator

    verify whether you can connect to sql server instance from sql server management studio

Share This Page