November 9, 2015 at 8:18 pm
I have an excel spreadsheet that I need to import into SQL 2008 each week. I have set up a job to import and add the data to an existing table by appending it. I then want to delete the excel file so that it does not get duplicated. As we do not know when the data is ready each week I have set up for the import to be scheduled every 1 hour between 9:00 am and 5:00 pm.
I thought I had seen how this was done before but cannot seem to find anything. Is there any way of doing this using the "New Job" wizard in Server Management Studio?:-D
November 9, 2015 at 8:59 pm
one way is to create an SSIS package that does the import and then deletes the file once the import is complete. Then you would just schedule the package to run whenever you wanted.
November 9, 2015 at 10:41 pm
Many thanks. Was not as easy as I thought but have managed to stumble my way through and managed to get it to work. Have recorded it in my "Notes" for future reference.:-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply