Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rupalim
Starting Member
20 Posts |
Posted - 2010-08-11 : 05:33:58
|
Hello everyone, My users have an Excel file that needs to be imported into SQL once in a while. This does not happen on a regular basis. Whenever they have data, they would like to copy it to a folder on the server. This Excel file should always has the same name. I created a SSIS package already to import the Excel file into a SQL table. The question I have now is: Can I trigger/run a SSIS package inside a SQL stored procedure? |
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-11 : 05:53:25
|
duplicate! |
|
|
|
|
|