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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy