automate weblink to csv to database

• Lavanyasri

  SSCarpal Tunnel

  Points: 4907

  More actions

  December 1, 2015 at 6:15 am

  #305714

  Hi ,

  i need to automate on the below

  1.call the webservice link , it will generate one csv file

  2. move csv file data into sql server database

  3. it should run every day and overwrite the existing table data

  Is there anyway to o this ?

• Thom A

  SSC Guru

  Points: 99128

  More actions

  December 1, 2015 at 9:59 am

  #1843263

  There is a Web service task which you can call the Web Service from, and a File System task which can copy files.

  You'll need to configure each node appropriately for your own needs.

  You would use the Server Agent to Schedule the task to run daily.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk