Post reply

BULK INSERT

  • July 9, 2008 at 2:38 am

    #381573

    Hi All

    I need to insert the rows of file into database, but the problem is that the file which i want to process is on one server and my database is on another server.

    Is there any way by which i can process that file directly through BULK INSERT.

    Cheers

  • July 9, 2008 at 8:18 am

    #840185

    You can try DTS. Create a DTS for this and execute to transfer data.

    -Vaseem

  • July 9, 2008 at 8:26 am

    #840192

    There are 2 viable methods

    1. BCP , if ur file is at different server and u can access this file on ur ur server then u can use UNC naming convention to access this file and dump data into Database.

    2. DTS or SSIS , Just dig in for with appropriate option .

  • December 17, 2008 at 1:50 pm

    #914146

    We found in 2005 BULK INSERT wouldn't work when running under a Windows-authenticated account and importing from a UNC path. If you run under a SQL login, it should work (provided the network permissions are set up correctly)

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

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