Stop and Restart Data flow tasks in SSIS

• subahan_syed

  Right there with Babe

  Points: 721

  More actions

  April 16, 2015 at 1:22 am

  #316650

  Hello -

  I'm running an exercise on SSIS for a mass data pull extract and my admin won't allow me to run everything at one shot. I don't want my admin to monitor my queries and he has a threshold of 1 hour for any query. If it exceeds then he would kill it automatically. So I have created multiple data flow tasks for the same extract by breaking the query using the time period.

  I wanted to check if there is a way to stop and restart SSIS between each data flow task without having to do it manually.

  Please help.

  Regards,

  SS

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 16, 2015 at 1:55 am

  #1791254

  subahan_syed (4/16/2015)

  ---

  he has a threshold of 1 hour for any query. If it exceeds then he would kill it automatically.

  A very bad design. Talk to him and explain why it's not a good idea.

  No technology is a subsitute for common sense.

  -- Gianluca Sartori