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)
 Looping a Package

Author  Topic 

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-10-09 : 07:00:13
Hi Guys

I have a package which runs everyday every hour. However i need to change this so that the package automatically starts again once it has been completed. Is there a loop feature that I could use?

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-09 : 07:03:14
i think you can configure a job in sql agent to call and exceute this package with high frequency schedule may be a minute or so. What's the purpose of executing the package continuosly?
Go to Top of Page

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-10-09 : 07:15:34
Hi

Thanks for that.

Its basically for website updates, so that the website can be updated as soon the update has bee processed.
Go to Top of Page
   

- Advertisement -