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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".