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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2009-08-14 : 17:39:03
|
| I am trying to load the data using SSIS(sql 2005) from about 5 excel spreadsheets automatically based on the following condition:When ever the user updates those excel spreadsheets, the SSIS package should take those spreadsheets and automaticallyload the data into the table. I am not sure how to do this, please let me know how I can do this using SSIS packages. Thanks much! |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-15 : 07:06:05
|
| Will the user close the file after updating? SSIS cannot open the Excel file if someone else has it open.So you may need to make a temp copy of the file.Will the package execution be triggered by a User (button in Excel)? Or will you use a scheduled task (check every 5 minutes)?To load the data from Excel, have a look at this: http://support.microsoft.com/kb/321686You may not require SSIS to load the data. |
 |
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2009-08-17 : 10:14:47
|
| Yes the user will close the excel file after updating. I was thinking of scheduling the SSIS package every 1 hour. Please let me know how I can do this using SSIS package. Thanks. |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
|
|
|
|
|
SSIS help