Post reply

DTS_E_OLEDBERROR

  • April 28, 2009 at 12:17 pm

    #202640

    Executed as user: BCPDOM\u19846. ...n 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:14:55 AM Error: 2009-04-28 11:15:35.26 Code: 0xC0202009 Source: Dtsx_DWH Connection manager "(local).VOICETRANS" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host. ". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Login failed for user 'BCPDOM\U19846'.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot open datab... The package executed successf... The step succeeded.

    Jose Luis

  • April 28, 2009 at 12:51 pm

    #985399

    Jose --

    It would appear the login under which the package is running does not have permission to the database it is attempting to access. Adding a log file to the package may also provide more verbose information.

    Nivek

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

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