• jerome.morris (8/11/2013)


    The file is 600mb + that I am trying to get to the tables, could I import all as string then copy to another table and parse on way. ? Or do you still advise using code ?

    That's a common technique, but parsing before loading is more efficient. Then again, it depends on what fits in your overall situation.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]