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 1:33 pm

    #1730422

    Lowell (7/17/2014)

    if it is plain text, i'd just use bulk insert instead of building an SSIS package;

    for me, that would be faster than anything else.

    I'm thinking you're gonna have to do some serious manipulation on that .rpt file to load it to SQL tables, in which case I'd want the transformation capabilities of SSIS.

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