Post reply

Using Bulk Insert for staging with SSIS ...with tables

  • September 4, 2008 at 8:23 pm

    #154697

    HI all...

    I want to know how can I use bulk insert with tables as it shows only flat file option...

    Any help ???

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • September 5, 2008 at 12:46 am

    #867588

    As far as I know bulk insert is for use with flatfiles.

    You can insert using commit batch sizes, which should improve your performance

  • September 5, 2008 at 6:31 pm

    #868087

    Is there no other way to do bulk insert

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply