rwheeler23
asked on
SSIS and a comma within text fields insist on breaking one field into two fields.
I have two very similar queries pulling this column value out of a table. These queries are embedded into two separate SSIS csv flat file export packages.
[Zone Location]
(42.628714605774775,-73.76 3909085255 904)
(42.636101731163215,-73.78 1746725049 999)
(42.666456988124622,-73.76 9417826333 267)
(42.696827302737731,-73.84 8687575844 366)
(42.644585953193598,-73.75 7813044036 51)
All fields in both tables are defined as varchar(max). The first export package works perfectly every time. The second one is giving me fits because when it goes from the SQL query to the csv flat file, it insists on braking this one field into two and after that all the subsequent fields are out of alignment. I have been staring at both packages and everything is set up the same except the query. How can I force SSIS to recognize this value as text and accept the comma as part of the field value?
[Zone Location]
(42.628714605774775,-73.76
(42.636101731163215,-73.78
(42.666456988124622,-73.76
(42.696827302737731,-73.84
(42.644585953193598,-73.75
All fields in both tables are defined as varchar(max). The first export package works perfectly every time. The second one is giving me fits because when it goes from the SQL query to the csv flat file, it insists on braking this one field into two and after that all the subsequent fields are out of alignment. I have been staring at both packages and everything is set up the same except the query. How can I force SSIS to recognize this value as text and accept the comma as part of the field value?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
love the bugs bunny reference.
ASKER
Thanks guys. I try to find humor in everything. Otherwise what is the point? Here is a great shot to liven your day. This was taken after one of the Mars rover landings.
MarvinMartian.bmp
MarvinMartian.bmp
Split
ASKER
Thanks
ASKER
Thanks All Around Good Guy!
P.S. I also learned a valuable lesson. The Preview button on the flat file does not show you data coming down from the SQL query it shows you what is currently in the flat file. I kept changing my script and could not understand the data was not changing. What a maroon I can be sometimes.