Hi,
I've used the import wizard in SQL server to import a table, and I've saved the package to a file. Now, how do I get the package to run again?????

My stuff is on a shared server, so IT department I guess has disabled the "jobs" stuff for me. At least I can't find anything like that when I look in SSMS. So IT says I they can schedule stuff for me but based on past experience I am very reluctant to put any part of my application in their hands.So I would much rather just have a stored procedure that imports the table, and then I call that stored procedure from Access. But how do I do this???? I can see how to create a new, blank table, but I can't figure out how to tell SQL server to populate it with stuff from an external source... my external sources would be either text files or Access tables.