Hi,
[OLE DB Destination [1146]] Error: An OLE DB error has occurred. Error code: 0x80040E23. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E23 Description: "Cursor operation conflict".
[DTS.Pipeline] Error: The ProcessInput method on component "OLE DB Destination" (1146) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
[DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0202009.
have any of u encountered this error?
package is working good on source side but destination is indicated in red with the above error,it was working good yesterday,not sure what happened today all of a sudden.
pls help!
Regards,
sg
That's an error returned from SQL Server so I would suggest the problem is in SQL Server rather than SSIS. That's not much help I know but hopefully it gives you some pointes about where to to investigate.
Google turned these up:
http://blogs.conchango.com/kristianwedberg/archive/2006/03/08/3045.aspx (from my friend and fellow Conchango-ite Kristian Wedberg)
http://support.microsoft.com/default.aspx/kb/324900
-Jmie
|||
Hi jamie,
Thanks a lot,ur information was valuable.The package is working.
|||Cool. If it proved to answer your problem, please could you mark it as an answer.
Thanks.
No comments:
Post a Comment