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 |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-05-08 : 06:11:29
|
| Hello All,I do have one table in which i have to enter data from excel file daily. I want to perform this task automatically by using ssis.Can any one help me?ThanksPrashant Hirani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-08 : 06:21:58
|
| Refer this link to create ssis package:-http://www.mssqltips.com/tip.asp?tip=1393And use SQL Server Agent to create & schedule a job that calls this SSIShttp://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx |
 |
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-05-08 : 07:41:45
|
| Thanks a lot. |
 |
|
|
|
|
|