• 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"