• bhoelzer - Tuesday, October 9, 2018 5:03 AM

    How do you handle the situation where you have some quoted strings, because of embedded commas, and some normal strings?

    For example:

    string1,1,2,3
    "string, 2",4,5,6
    string3,7,8,9

    Hi Bhoelzer, the bulk insert task is designed for performance, hence there is no way to perform validations with this component, you will have to replace the Bulk Insert Task with a Data Flow Task and perform a data cleansing there (or you can put another step before the bulk insert to format the file).
    Hope this helps!

    MCSE, MCSA SQL Server Database Developer/Administrator