Post reply

How Do You Set Up A Bulk Insert Task In SS 2005

  • May 20, 2008 at 4:29 pm

    #123922

    I've been scouring my 2000-page SQL Server 2005 manual, as well as the internet, for an hour now; and I can't understand why I cannot find any reference for how to set up a Bulk Insert (or equivalent) Task in SQL Server 2005. It's such a useful tool in SQL Server 2000 that I can't imagine that it's been discontinued; but I just can't seem to find it anywhere.

    Please help!

    Thanks

    djs

  • May 21, 2008 at 4:33 am

    #818458

    hi,

    to use balk insert in OLE DB destanation

    please use the data access mode

    the "Tabe or view - fast load "

    that would do .

    Yours

    Yaron.

  • May 21, 2008 at 11:22 am

    #818758

    There is a new type of bulk-insert as well. If your destination is the local SQL server, you can use the "SQL Server Destination" component. This does a new type of bulk insert that uses the file system (which is why it must be the local server) to load data faster than a traditional bulk-insert.

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

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