Post reply

BCP

  • October 21, 2003 at 12:32 pm

    #107217

    Hi All,

    I can't for the life of me find how to make a format file easily for use with a BCP Bulk insert.

    Must they be made by hand?

  • October 21, 2003 at 5:05 pm

    #479014

    You can use BCP to create the basic format file by outputting from your destination table.

    Using the DTS Bulk Insert task, click the 'Use format file:' option and then clck the Generate button.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 21, 2003 at 8:06 pm

    #479022

    where can I find DTS Bulk Insert task?

  • October 22, 2003 at 1:09 am

    #479032

    It's in the tasks group in the DTS Designer. The icon has a yellow database with a green arrow on the top.

    Also, if you right-click on the designer pane, then select 'Add Task' from the pop-up menu. Bulk Insert is number 9 on the list.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 22, 2003 at 11:19 am

    #479147

    Thanks once again Phill!

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

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