January 10, 2008 at 11:24 am
I have a job that calls a dts package. This package copies tables from a SQL server 200 database to another SS200 database. It failed today and I tried to reproduce the problem by running the DTS paackage again and this time it completed successfully. The error msg is the following. Let me know if you have any ideas why this failed?
Step 'DTSStep_DTSTransferObjectsTask_1' failed
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Received invalid column length from bcp client.
Step Error code: 800412CF
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131
Step Execution Started: 1/10/2008 5:00:01 AM
Step Execution Completed: 1/10/2008 6:42:38 AM
Total Step Execution Time: 6157.094 seconds
Progress count in Step: 0
Step 'DTSStep_DTSExecuteSQLTask_1' was not executed
Step 'DTSStep_DTSExecuteSQLTask_2' was not executed
January 10, 2008 at 11:43 am
Was the data in the client table different when the bcp failed? The error message seemed to tell me the length of one column in the client table was longer than the receiving table.
January 11, 2008 at 7:04 am
Today the same job executed succesfully as usual. I still do not know what happened yesterday.
No, the client table columns were the same as there was not changes. Yesterday I tried to reproduce the problem using the same destination and source database to run this SQL job that calls the stored procedure. In the end the job run successfully too. I'm still investigating why the job failed.
Oh anothing thing is when the SQL job failed yesterday the data was replicated fine. Means it replicated the records but the job failed with the above msg. It's so weird. Anyone could share some light?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply