April 27, 2011 at 8:06 am
Hi,
I have a table which I bcp out in a stored procedure. The Stored procedure is scheduled daily using a job which hasn't failed but the customer to picks the files is complaining of receiving only 3 rows instead of 100,000 rows.
The table has 100,000 on each of the days.
I want to know if the bcp command is atomic or not ?
bcp "Select * FROM Table WITH(NOLOCK)" queryout '+@DestinationLocation+'\\SomeFileName.csv -c -t, -T -S '+@@Servername
The above line is used for bcp ing out. Your inputs please.
April 27, 2011 at 8:11 am
I don't think it can be. How could sql server "rollback" previous write to an external location?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply