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 |
|
sqlpal2007
Posting Yak Master
200 Posts |
 Posted - 2011-11-22 : 13:22:48
|
| Hello All,My SSIS package exports the SQL data to CSV file. The first column doesn't show the text qualifier.(Microsoft Visual Studio 2008)For example:FName|"LName"|"Age"|"Department"Amy|"Green"|"30"|"Sales"These are the settings -Text qualifier: "Header row delimiter: {CR}{LF}Header rows to skip: 0checked column names in first row.Row delimiter: {CR}{LF}Can any one tell me why the first column is not around the double quotes?Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-22 : 23:59:30
|
| Its working for meWHats the datatype of Fname?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-11-23 : 00:06:29
|
| It is varchar. I tried shuffling int and varchar type columns but didn't show the qualifier for both the situations.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-23 : 00:29:00
|
| do you've some unprintable characters present in it. try taking DATALENGTH() and see------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sqlpal2007
Posting Yak Master
200 Posts |
Posted - 2011-11-23 : 08:57:45
|
| The DATALENGTH match to the actual length of the data. Could it be due to the service pack? |
|
|
|
|
|
|
Text qualifier "