Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drewj840
Starting Member
3 Posts |
 Posted - 2003-08-19 : 11:26:46
|
I am copying DTS packages from one server to another using BCP. This action is part of a larger script for change management control. I want to be able to determine whether the BCP was successful or encountered errors. One way I thought of was to check the size of the ".err" file and if it is zero, then the BCP was successful. However, this seems clumsy. Certainly there must be a better, more elegant way to determine if a BCP was executed successfully. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-19 : 11:34:58
|
| Best way is to have a count of the expected records and check that.BCP is a command line utility and any errors reported would depend on the way it is written and the way you call it.It is similar to dts in that it is possible to miss records and not report an error depending on the file format and table definition.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
BCP: how to determine success or failure