Running BCPs

[kizziebutler]

I do not know if this is possible, however I will ask the question? Is it possible to schedule, one BCP to run and execute, finish successfully and then execute another BCP command to run after the first one has run?

I am extracting 74 tables and views. One BCP per table or view. ie, BCP "select date from table" output "table1.txt". Some tables contain 90 million records. I run one BCP command at a time to ensure that the tempdb does not fill up to quickly and fail to execute successfully.

I was ask if I could write some procedures and run it over night to execute all the BCP commands. I know you can schedule the BCP command from sqlagent but this does not ensure that the execute has completed on time.

 

[mrdenny]

Check your other thread.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com