Home Forums SQL Server 2005 Business Intelligence Fixed Length Flat File RE: Fixed Length Flat File

  • March 14, 2011 at 7:43 am

    #1298318

    Jeff Moden (3/13/2011)

    josetur12 (3/13/2011)

    Thank you all again. WayneS' solution works.

    If you have the data to exercise Wayne's good solution, you might want to look into what a BCP format file does for performance. It contains mostly the same kind of data.

    Dang it, you did it again. 😀 I was waiting to see if he tried this, and was then going to suggest the same.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2