Member Avatar for Lido98

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

name;age;adress;compnay

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

Thanks a lot for your help.

  • 2 Contributors
  • 3 Replies
  • 105 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by Lido98
Member Avatar for punitdam

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

Member Avatar for Lido98

Hi again

It is 2005 version.

Thanks

Member Avatar for Lido98

Thanks, I have created the job .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.