i have a sever connection and a text file destination. I double click on the black line to set up transformation. The options tab has so you can export to comma seperated columns. When i run it, it doesnt seperate the columns with a comma. Also i want my text qualified with double quotes, which is an option also but it doesnt do that either. How come???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS Export to CSV
- Thread starter bjr149
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Check the properties of the Text file Destination not the transformation.
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question