I have an SSIS job which imports data from a CSV file to a table in a database. It worked fine on our old SQL Server 2008 box, but fails on the new SS 2017 box, as the new import facility sees a comma within a text field as a delimiter. Short of writing a script with a lot of complicated regex stuff in it to edit the input file to something SSIS can read, is there anything else I can do? Surely something as elementary as this must be a known problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SSIS importing flat file (CSV)
- Thread starter Vronsky
- Start date
Similar threads
- Question
- Locked
- Question