December 23, 2002 at 12:28 pm
I've saved several dts packages from a sql7 server to a sql2000 server. Most work however when I try to execute 2 in particular I get this message. "The number of failing rows exceeds the maximum specified. Insert error,column 5('Assoc_NO',DBTYPE_NUMERIC),status12:Invalid status for bound data. I can execute these packages sucessfully from another machine. Just not from the server that the databases are on. The packages first delete data in the target table then are importing data from TeraData. When I do a workflow properties preview of the dts step that copies the data from Teradata to Sql table the values all show up as -4225892347. I'm sure I have the DSN & the odbc drivers the same on the local server as the one I successfully run the package from.
December 23, 2002 at 12:31 pm
You might try re-creating your dts connection object on the server you are running the packages on...
hth,
Michael
Michael Weiss
Michael Weiss
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply