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.
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.
