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 17, 2014 at 10:19 am

    #1730343

    Since it's from SSMS, it's likely just a standard text file .rpt, rather than a Crystal Reports .rpt.

    I suggest using SSIS to import that data. It will of course be a fairly long process to read, interpret and load 100GB of text data.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.