Post reply

SQLBulkCopy in SSIS?

  • October 20, 2008 at 1:00 pm

    #124416

    I was just curious if it is possible to use the SQLBulkCopy class (VB.Net) in SSIS and if so if somebody could give me an example script that would be wonderful.

    I have read that is a very quick tool for importing data and wanted to know if I could it in SSIS.

  • October 21, 2008 at 11:50 am

    #887760

    I am not a great expert of VB.Net. If you could execute SQL command in your VB.Net then Bulk Insert command might be helpful. You could have more information in help file, searching for Bulk Insert.

    Hope this helps,

    Rajesh

  • October 21, 2008 at 11:53 am

    #887761

    Thank you for your timely response.

  • October 24, 2008 at 2:58 pm

    #889496

    I'm wondering why do you want to use this class? You already have SQL Server bulk-insert SSIS destination component.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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