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 |
|
amirs
Constraint Violating Yak Guru
260 Posts |
 Posted - 2008-05-30 : 07:12:48
|
 hihow i can write to store procedure to use bulk insert command to import database table to csv file . i have append record to existing record so how i can write please help......... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-30 : 08:10:19
|
| Did you have a look at BULKINSERT command in books online?http://msdn.microsoft.com/en-us/library/ms188365.aspx |
 |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-30 : 10:55:55
|
| Or even bcp in BOL? I use that in a number of places to produce csv files for pickup by clients (I'm guessing you meant "export" database table??). DTS could even do this. If you're stuck, post the script that you're working on and someone will surely help.Terry |
|
|
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-05-30 : 11:37:25
|
| can you help about how to use dts to import database table in csv file |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-30 : 12:27:14
|
quote:
Originally posted by amirs
can you help about how to use dts to import database table in csv file
There's a wizard version available in Enterprise Manager. You can launch and select source and destination connection mangers and it will do transformations and transfer for you. |
|
|
|
|
|
|
BULK INSERT