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 |
|
Rekha
Starting Member
14 Posts |
 Posted - 2008-06-30 : 09:24:31
|
| Hi,I have created a DTS which has SQL server as Source and TExt file as destination.I need double quotes for text data including Dates column, is it possible to have double quotes for dates column while exporting data from DTS??Currently it adds souble quotes only to text column, please helpThanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-30 : 22:25:38
|
| Try convert date column to text first. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-01 : 01:26:33
|
| You can also do this conversion in transform data task itself.http://doc.ddart.net/mssql/sql2000/html/dtssql/dts_elemtr1_33jn.htm |
|
|
|
|
|
|
Double quotes for dates