June 30, 2004 at 10:59 am
We have an application that generate text files that are to be loaded into the database using BCP. This is a 7-col table with 4 cols that are not nullable. Unfortunately one of the non-nullable column is missing from the text files due to an applicaiton bug. Since there is no immediate fix to the application itself, I'd like to know if it is possible to use an insert trigger to insert a dummy value into this missing column immediately after BCP inserts a record into the table. Manually fixing the files is not an option because I'm getting over 5000 such files everyday and it is an on-going process.
June 30, 2004 at 11:22 am
One option is to set a default value to that particular column.
July 2, 2004 at 3:53 am
Thanks, Arun. Your suggestion works perfectly!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply