Post reply

SSIS Error Code DTS_E_OLEDBERROR

  • February 14, 2012 at 4:42 am

    #149072

    Hello

    Test connection between two server works using Universal Data Link (.udl).

    Source server running SSIS is sql server 2005(32bit) and destination server is sql server 2008 (64bit)...hopping that should not be a problem.

    sql user used to run a job and to connect is sysadmin on both server...

    but while running ssis package i got following error...

    PLEASE HELP !!!

    Executed as user: AAA\XXX. ...Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 10:57:38 AM Error: 2012-02-14 10:57:45.29 Code: 0xC0202009

    Source: Sour Public Table Transfer Connection manager "Desti Database Connection"

    Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.

    Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'ssis_desti01'.".

    End Error Error: 2012-02-14 10:57:45.29 Code: 0xC020801C Source: Transfer Public DiaryEvent Record OLE DB Destination [457]

    Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager

    "Desti Database Connection" failed with error code 0xC0202009. There may be error messages posted before this with more informa...

    The package execution fa... The step failed.

  • February 14, 2012 at 8:17 am

    #1446863

    sandip1981 (2/14/2012)

    Executed as user: AAA\XXX. ...Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

    Started: 10:57:38 AM Error: 2012-02-14 10:57:45.29 Code: 0xC0202009

    Source: Sour Public Table Transfer Connection manager "Desti Database Connection"

    Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available.

    Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E4D Description: "Login failed for user 'ssis_desti01'.".

    I have highlighted the relevant issue.

    CEWII

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply