Hi friend

I have a question of 2 parts
I have to insert new entries from a file in a table once every month
Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of the fiields an not all the fields for instans I have the following file struktue


But I want only to insert name and compnay in the table.

Thanks a lot for your help.

You can create job.
Job can be scheduled as per your need.
Which MS SQL version are you using?

Hi again

It is 2005 version.


Thanks, I have created the job .