I currently have a product server and a development
server, Once a week we transfer the production database to
the development database.

To do this we use a DTS package that uses the Copy SQL
server objects task.

This works but the job in sql is always flagged as failed.
After looking through the log file the following error
occurs.

::Error::
In file in statement on line 0
Transfer Status: Transferring Data: (Table '[dbo].
[TABLE1]')
[Microsoft][ODBC SQL Server Driver][SQL Server]Received
invalid column length from bcp client.

I have search for more information on this error but thus
far have come up with nothing. The error number is 4815
and the error severity is 21.

If anyone has any info for this it would be greatly
appreciated.

Thank you
Clint

Personally if you are going to transfer the whole shebang once a week to the
dev server then forget doing it this way. It is protracted for what you are
doing. BACKUP the database and RESTORE it.

As for the error.

Check the definition in the .fmt files for the table in question.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Clint" <anonymous (AT) discussions (DOT) microsoft.com> wrote