SQL Server Performance

Package error

Discussion in 'SQL Server 2005 General DBA Questions' started by viksar, Feb 26, 2007.

  1. viksar New Member

    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.
  2. ghemant Moderator

Share This Page