How to schedule package Continuoulsly?

Hi,

I have requirement that i need to Schedule package continuously(every 10 Seconds).

Any solution on this?

it would be great!

H there,

I'm afraid that 2005 doesn't give you the possibility to launch processes on seconds-basis, so you could do a little vb application where inside a loop and using a Timer..:

Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package

Dim EventsSSIS As Eventos

Dim app As New Microsoft.SqlServer.Dts.Runtime.Application

while true..

pkg = app.LoadFromSqlServer("msdb\yourpackage", Nothing, Nothing, Nothing)

sResultDts = pkg.Execute(Nothing, Nothing, EventsSSIS, Nothing, Nothing)

stuff..

Public Class Eventos

Implements IDTSEvents

OnPostValidate()

OnPreExecute()

..

stuff

|||Hi

I have two suggestions:
- you could reorganize your package to use an never-ending for loop, with a ~10 seconds sleep (I would try to do that first, if you have the possibility to modify the package)
- or use a scheduler (sql jobs, or third party software like nncron or cruisecontrol.net to trigger the package execution) - keep in mind that if you have to launch it every 10 seconds, it may end spending more time just starting and stopping compared to the time really used to carry out the transformations...

Thibaut|||

Sivarama wrote:

Hi,

I have requirement that i need to Schedule package continuously(every 10 Seconds).

Any solution on this?

it would be great!

Is SSIS really what you want here?

SSIS is inherently a batch tool. If you want something more real-time then perhaps BizTalk is what you're after.

-Jamie

|||Although you should have an "end process trigger", I would suggest using a for task, place all your stuff in it and just say while @.endtrigger = 0.

I have had a similar issue with trying to run things every 1 min, 10 sec is a little fast I think. On my server it takes an SSIS job 1 min 34 secs just to START the job. This makes it very hard to say, look for a file over and over, until it finds it.