I get the same error code when I run it under myselfĮxecuted as user: OIARAD\sqlagent.on. There may be error messages posted before this with more information on why the AcquireConnection method cal. The AcquireConnection method call to the connection manager "BNAWPAFDB02\FINANCIALS.OIA_CUSTOM" failed with error code 0xC0202009. End Error Error: 14:31:40.63 Code: 0xC020801C Source: Data Flow Task OLEĭB Source Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Source: Insurance CPID EMC List Connection manager "BNAWPAFDB02\FINANCIALS.OIA_CUSTOM" Description: SSIS Error Code DTS_E_OLEDBERROR. DBA made shre the "SA" has all authority needed.Įxecuted as user: OIARAD\sqlagent.on. Step 4 : Send mail to a central location.(never gets to this point)įollowing is the error message I keep getting. ![]() Step 3: Data Flow Task LOE DB Source acces table that was just populated and takes data and drops into Excel spreadsheet. Step 2: Excecute SQL task running a stored procedure that populates at table on SQL Server 2005 Step 1: copies excel 2003 template to 2003 excel that will be populated ![]() I created SSIS package, which runs no problem in SSIS 2005 development.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |