How can we execute a task or container for every 30 minutes in ssis .

Question

Can any body help..

How can we execute a task or container for every 30 minutes in ssis .

---

sunny

Answer 1

You can create a separate package for the task which you want to execute in every 30 minutes and then schedule that package with SQL Job Agent to run in every 30 mintues.

 

 

 

---

Cheers, Shailesh

Answer 2

a Task or Container stand alone - no

create a SSIS Package whith the Task or Containe rin and then create a Job in SQL Serverwith a schedule  to start the package every 30 Minutes

Answer 3

Thanks for the suggetions..Is there any mechanism to delay in executing a container..For example,i want to execute the final dataflow task ,after waiting for 30mins..

---

sunny

Answer 4

Use for Loop Container before your DF task 

In EvalExpression give this below expression to wait for 30 minutes.

DATEADD( "minute",30, @[System::ContainerStartTime]  ) >  GETDATE() 

Answer 5

you can use script task before conatainer to make package to sleep for a time

use this VB .net  code in script task

System.Threading.Thread.Sleep( time )

 

or use alternative explained in Jamie's blog

http://consultingblogs.emc.com/jamiethomson/archive/2006/10/23/SSIS_3A00_-Put-a-package-to-sleep.aspx

 

this will make your package to stop for given time only when package will execute.

---

Cheers, Shailesh

Answer 6

ZOMG - do NOT use the For Loop Container "delay technique"  It'll just waste CPU cycles.  Use the Script.

---

Talk to me now on

Answer 7

If you already have a OLE DB connection, for instance, than in my opinion the easiest way to execute something over and over again (maybe waiting for a file to appear on a FTP server or a certain value in a database to change) is to set it up inside a For Loop Container and add an Execute SQL Task as the first step. You then choose the OLE DB connection as Connection in the Execute SQL Task and add the following SQL code in SQLStatement: WAITFOR DELAY '00:01' (this stops the package for 1 minute and then goes on). Then you just to fix your logic in the For Loop Container to match your needs, for example you may want it to run only a certain amount of times or only between certain times of the day, and so on. But that's just For Loop Container settings.