Package error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Package error

I am running a Package and its running within SQL server. SQL server is SQL 2005 with SP1. This package was working fine before, but all of sudden it stop executing. Now its coming with these type of error messages. Any Clue ???
OnError,MORNINGSIDE,PATCHsqlexecaccount,transfer minimums,{643276EE-1923-4328-9FDF-47A25EB999EF},{20825AC3-C1EF-4A4D-868D-822A7D6C0C86},2/27/2007 11:19:14 AM,2/27/2007 11:19:14 AM,-1071607767,0x,The "input "OLE DB Destination Input" (53)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (53)" specifies failure on error. An error occurred on the specified object of the specified component. OnError,MORNINGSIDE,PATCHsqlexecaccount,D&B interface live,{B814FFEB-DC75-4CED-A5D2-75A18FA120CA},{20825AC3-C1EF-4A4D-868D-822A7D6C0C86},2/27/2007 11:19:14 AM,2/27/2007 11:19:14 AM,-1071607767,0x,The "input "OLE DB Destination Input" (53)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (53)" specifies failure on error. An error occurred on the specified object of the specified component. OnError,MORNINGSIDE,PATCHsqlexecaccount,transfer minimums,{643276EE-1923-4328-9FDF-47A25EB999EF},{20825AC3-C1EF-4A4D-868D-822A7D6C0C86},2/27/2007 11:19:14 AM,2/27/2007 11:19:14 AM,-1073450974,0x,The ProcessInput method on component "RetailDB" (40) failed with error code 0xC0209029. 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. OnError,MORNINGSIDE,PATCHsqlexecaccount,D&B interface live,{B814FFEB-DC75-4CED-A5D2-75A18FA120CA},{20825AC3-C1EF-4A4D-868D-822A7D6C0C86},2/27/2007 11:19:14 AM,2/27/2007 11:19:14 AM,-1073450974,0x,The ProcessInput method on component "RetailDB" (40) failed with error code 0xC0209029. 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. OnError,MORNINGSIDE,PATCHsqlexecaccount,transfer minimums,{643276EE-1923-4328-9FDF-47A25EB999EF},{20825AC3-C1EF-4A4D-868D-822A7D6C0C86},2/27/2007 11:19:14 AM,2/27/2007 11:19:14 AM,-1073450975,0x,Thread "WorkThread0" has exited with error code 0xC0209029. OnError,MORNINGSIDE,PATCHsqlexecaccount,D&B interface live,{B814FFEB-DC75-4CED-A5D2-75A18FA120CA},{20825AC3-C1EF-4A4D-868D-822A7D6C0C86},2/27/2007 11:19:14 AM,2/27/2007 11:19:14 AM,-1073450975,0x,Thread "WorkThread0" has exited with error code 0xC0209029.
Hi,
Refer below threads discussing same issue:
http://www.sqlservercentral.com/acc…/shwmessage.aspx?forumid=148&messageid=327671
andhttp://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1247055&SiteID=17 Regards
Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
]]>