troubleshooting Question

Problem importing a comma delimited file

Avatar of martyuni
martyuni asked on
Microsoft SQL ServerMicrosoft SQL Server 2008
7 Comments1 Solution403 ViewsLast Modified:
I am building an SSIS package in SQL Server 2008.  One part of it is Data Flow Task that has a flat file being imported into a table in my database.  I go into the task and create a Flat File Source.  I point it to a txt file provided by another department.  The file has fields seperated by commas and the data inside of double quotes for each peice, but it is not a csv file type.  So I set the format as delimited, text qualifier as double quote, and column delimiter as comma.  My problem is that in one of the fields they have a comma in the data which the connector is making into a new field.  Here is an example:

"LastName","FirstName","Clerk II","Health, Physical Educ & Leisure Services"....

This is being imported as

Clerk II
Physical Educ & Leisure Services  (instead of Health, Physical Educ & Leisure Serivces)

How can I import that correctly?
Reza Rad
Consultant, Trainer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros