jokiz » bcp and errorlevel checks
ATTENTION: I've decided to put the upgrade on hold due to a compatibility issue of our server environment with the latest CS installer package. CS 2008 now requires SQL Server 2005 as the backend DB but our database server currenlty has SQL Server 2000 installed on it. I'll resume the upgrade once I figure out when Telligent is releasing a patch to the schema compatibility issue. For now, we will continue to use the old version of CS while waiting for the said patch. If you have any questions about this process, please don't hesitate to post them on our forums and I'll answer them as soon as I can. Thanks for your patience and support guys! I'll let you know as soon as this is resolved. - Keith Rull

bcp and errorlevel checks

we have a number of batch scripts at work which executes sql-related tasks for each of our project releases.  last time, i incorporated errorlevel checks so we know if there was a problem with the execution and in order to abort the rest of the operations if something else has gone wrong. 

i was surprised this weekend when one the bcp operation failed but it continued to execute the latter commands.  it turns out that the errorlevel variable is not populated correctly by bcp version 8 which comes with sql server 2000 (see kb here).  Luckily, it was already resolved with bcp version 9 which comes with sql server 2005.

Posted Dec 17 2007, 11:54 PM by jokiz
Filed under: ,

Comments

online met Boskamp %2526 Willems Advocaten wrote online met Boskamp %2526 Willems Advocaten
on 02-10-2008 10:20 AM

The proper way to track down this information is to use all means at your disposal.

Add a Comment

(required)  
(optional)
(required)  
Remember Me?

Enter the numbers above:

Copyright DevPinoy 2005-2008