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 |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2005-07-25 : 11:02:00
|
| I want to import data into a CSV file.In the DTS Export Wizard, what option do i choose for the Destination. Is it Microsoft Text Treiber (.txt , .csv)....or something else???? |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-25 : 19:05:27
|
| Got it in one. |
 |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-26 : 04:53:28
|
quote:
Originally posted by timmy
Got it in one.
Some explanation would do  |
|
|
|
SMerrill
Posting Yak Master
206 Posts |
Posted - 2005-07-26 : 22:13:07
|
| That's Aussie for "you got it correct on the first try."~ Shaun MerrillSeattle, WA |
|
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-27 : 10:21:50
|
| I guess u both mean that Microsoft Text Treiber (.txt , .csv) is the correct option. But what do I put for 'User/System DSN' or 'File DSN' in the Destination screen.I basically want to export data to a csv file. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-27 : 18:53:13
|
| This way means you have to set up a DSN for the text file you want to use as a data source/destination. However, if you select 'Text File' from the Export Wizard 'Choose a destination' dialog, you can specify the destination file name and that's it. Apologies for the flippant remark earlier.....Tim |
|
|
|
|
|
|
Importing to CSV file