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)
 Running a process

Author  Topic 

powellbound
Starting Member

23 Posts

Posted - 2008-08-13 : 13:17:24
How do I setup a process to run constantly. Right now it runs to completion and stops but I want it to go back to the first step and start over.

TIA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 13:22:57
run constantly? do you periodically according to a schedule? then create a job to execute process and then schedule the job to execute periodically.
Go to Top of Page

powellbound
Starting Member

23 Posts

Posted - 2008-08-13 : 14:26:12
I figured it out. Put a for loop around the code and that loop never ends. Pretty cool.

Obviously, I am new to SSIS and SQLServer after years in the Oracle/Peoplesoft world but am liking this.

Thanks to all for their help and patience.

David
Go to Top of Page
   

- Advertisement -