I'm using Integration Services to insert rows into a SQL Server 2008 table, and I'm receiving an error - only when the table is empty before the insert. I use SSIS quite frequently, and this is the first time I've seen this kind of issue. Since
I'm getting some internal errors that seem related to the engine in the reports, I figured I'd post here for ideas.
Here's the dump from the Agent job that runs the package:
Executed as user: CORP\_DWAdmin_Service. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:38:29 PM Error: 2010-10-11
20:39:14.14 Code: 0xC0202009 Source: Insert New Records DIM_CUSTOMER  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 Server Native Client 10.0" Hresult: 0x80004005 Description: "Warning: Fatal error 3624 occurred at Oct 11 2010 8:39PM. Note the error and time, and contact your system administrator.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x800
View Complete Post