Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-08-14 : 17:04:48
|
| Hi Folks.I have a stored procedure which stores records in a table. I want to bulk copy out the data in the table by executing the bcp command from the stored procedure. Is this possible?Or Should I call a DTS package using the stored procedure?Thank youByeRamdasRamdas NarayananSQL Server DBA |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-14 : 17:23:52
|
| You can use either bcp or DTS. If you use DTS, you should create the DTS package and save it, then schedule the package for execution. You can put in any schedule you like and change it later (or even remove it). This will create a job that runs the DTS package, and you can start it manually using sp_start_job.If you want to use bcp, you can find some details here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12580Also look in Books Online for more information. |
 |
|
|
|
|
|
BCP out data from a table.