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 |
|
stan9186
Starting Member
7 Posts |
 Posted - 2007-07-04 : 00:34:19
|
| Dear all,Do anyone knw that how am I gonna write data from a DB table to TextFiles(.txt)? If use Flat File Destination, how do I do the setting? |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-04 : 05:59:00
|
| Hi,You need to go to data flow, choose for the data flow destination "flat file" and for data flow source OLE DB source.choose for data flow transformation "data conversion".when you right click on the data conversion object you need to specify output columns, just give it an another name, you can handle that later. when you choose de destination file you can change the mappings, just delete the transformations that have an another name, I hope this helps for you.kind regards,BenjaminNeed an SQL consultant?check www.veeningsengineering.nl |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 17:09:23
|
| Or just use bcp. |
|
|
|
|
|
|
How to write data from DB table to TextFiles