Post reply

Which way is better to port around 60000 data into database automatically per day

  • December 1, 2009 at 3:42 am

    #137171

    Hi,

    Which way is better to port around 60000 records from one CSV file into database through schedular per day (every day old data will be removed and new data will be inserted). For time being, m using select * from openrowset query in one sp and create a schedular for that.

    but if i need to execute that sp, admin privilege is needed. is there any other way to achieve this?

  • December 1, 2009 at 5:58 am

    #1085714

    You can achieve this using bcp or BULK INSERT. You can also try SSIS or DTS

    Regards..Vidhya Sagar
    SQL-Articles

  • December 2, 2009 at 3:06 am

    #1086331

    Thanks a lot.

    let me try these option.

  • December 2, 2009 at 11:21 pm

    #1086905

    BULK Insert or BCP are specifically for importing lot of data into sql server. If you are using either of them inside a procedure you can create a job that calls the procedure and schedule the job.

    SSIS also internally uses the same and it can be scheduled.

    "Keep Trying"

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

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