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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 question regarding ssis

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!
Go to Top of Page
   

- Advertisement -