Home Forums SQL Server 2008 SQL Server 2008 - General How to efficiently import data in .rpt format into SQL 2008 RE: How to efficiently import data in .rpt format into SQL 2008

  • July 18, 2014 at 1:22 pm

    #1730750

    halifaxdal (7/18/2014)

    Here is the format file, .xml is changed to .txt to get uploaded on this forum. Thanks.

    I think the issue is the last column, like I indicated in previous post, the last column is NOT a width fixed column, in some cases it is 0, in some cases it is a big number

    BTW: I have posted both my test data and format file here in this thread, everyone can you please try them out on your environment, thank you very much.

    hi Halifax...I am no bcp expert...far from it.

    however, and for what its worth....I could import your test data using SSIS import wizard with ragged right format on the flatfile data source.

    regards

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day