December 1, 2008 at 9:19 am
Richard,
Drama starts after appending!
Now with automatic appending they will have to write another 100 lines of code to prompt for the timely cleanup, checking for the file size, drive space, implementing file roll over etc. Not even talking about the process that will consume the output data, how this process will determine what are the new data. Don't tell me about the log files, they are not normally created by BCP process.
Regards,Yelena Varsha
January 21, 2009 at 1:46 pm
I think i could not get the question correct, as BCP we can append data into table. but it overrites flat file.:):)
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
February 22, 2011 at 11:23 pm
Dear Sir , your wrote: " I'd either use bcp to output to a temporary file and then concatenate the two together".
Please tell me that how would this be implemented.
I want that when i insert a record in a table in sql then a trigger is fired on the insert , which executes a stored procedure , the procedure appends the new record into a text file in my C drive.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply