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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.