• Try out what Scott has suggested. I have not tried it myself, but his theory seems good. I've had to deal with some pretty crazy files over the years. If things get too crazy, I usually resort to adding a Script Task and using C# to clean up the file so SSIS can easily read it in. I do that now for a file that is around 80 MB and it only takes a couple of minutes to read it, apply rules, and create a SSIS friendly file.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden