I have two things that I need to do. I have a csv file that comes from our distributor. It sits and is updated everyday on their website. I would like to automate a table to be dropped and updated with this information everyday. Then I can use some procs to do with it what I need to do with it.
Second I would like to do what ever he is doing and create my own csv file that is outputted from a proc's output everyday. I have the proc setup so when it is run it will pull the information I need and then I copy it to excel. I would like to take the idiot user who is going to mess it up (me) out of the equation. Is there anyone that can help me with how to do this? Thanks, Ben.