Post reply

How to Bulk Insert using multiple input files ?

  • May 5, 2009 at 4:03 pm

    #209177

    I am trying to import multiple input .txt files, from one folder, using bulk insert.

    I can import one fine, but when i use filename:

    'c:\users\administrator\desktop\load\*.*'

    it does not work.

    I found some examples from 2004 on google but was wondering if there was a newer method.

    Thanks

  • May 6, 2009 at 12:43 am

    #989350

    create SSIS package to do the same which is having more functionality.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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