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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2011-02-15 : 02:24:55
|
| Dear All,I am extracting the Address fields from the varchar field and its separated by comma in the address field to a .csv file format using SSIS.When loading from the SSIS .csv file one field is shifting because of one comma in the address field.How do we avoid this.Thanks,GangadharThanks,Gangadhara MSSQL Developer and DBA |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-15 : 03:02:30
|
| You might need to cleans the all Commas in a single unit of Address before you parse it as an Input via the module. By the way I faced same kind of issue when i was working with extraction of some large set information from database to excel files. CheersMIK |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
CSV file separation