Hi All,
Is there a way I can download a file from Sql Server using any stored procedure???I have written a DTS package which works fine from the EM but it fails to run as a scheduled job.

My schenerio is to: Download a CSV file from a website,Process the CSV file(as it contains some comments) and then append the data to a Sql Server table.

What could be the best way?