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 |
|
fia999
Starting Member
2 Posts |
 Posted - 2012-05-08 : 12:02:04
|
| Hello-We have a DTSX package that was imported from SQL 2000 that is not generating double quotes correctly in SQL 2008. The package works in SQL 2000. Expected result:"Flat I-22, Block ""I"", Diamond District"Actual Result:"Flat I-22, Block "I", Diamond District"Please help. Thanks you guys!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 12:28:02
|
| whats the destination its writing data to? is it flat file or sql table?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
fia999
Starting Member
2 Posts |
Posted - 2012-05-08 : 12:52:34
|
| it is a csv file. it is eliminating the extra pair of double quotes in SQL 2008. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 16:18:46
|
| what have you specified as text qualifier in connection manager for csv?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
DTSX package not generating double quotes properly