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
 SQL Server Administration (2005)
 Need Help to create ssis

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?


Thanks
Prashant 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=1393

And use SQL Server Agent to create & schedule a job that calls this SSIS

http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx
Go to Top of Page

hirani_prashant
Yak Posting Veteran

93 Posts

Posted - 2008-05-08 : 07:41:45
Thanks a lot.

Go to Top of Page
   

- Advertisement -