July 30, 2009 at 2:52 pm
HI all,
i have a scenario to limit the number of records from Source data while executing the DTS package. So i am doing this by 2 months at a time.
I want to change the date values dynamically while executing the procedure.And i also want to stop the process once and restart it after 1 minute.
Becuase source had CLOB data and when i run the DTS package it fails after 1500 records.
Here is the Scenario i would like to do
I want to create a temp table having l the dates starting from 01/01/2009
it should run for 2 months and stop for a minute.
Then start again and look for date from 1st of march, then load for 2 months and stop again.
Can we acheive above scenario???
It would be really great if someone did this kind of scenario and if they can shre that with me.
Thanks all...
July 31, 2009 at 5:45 am
I would set a for loop and inside it have a script task that sets a variable with the sql command needed for the current 2 month block. then exectue the data flow using the sql command from variable. After execution run another script task that runs a timer for 1 minute. Then the loop starts again you update the sql command for next 2 month block, execute the data flow and .....
Have a boolean variable set to true, once you have executed all the 2 month blocks set it to false and the loop ends. Use this variable in the loop test condition.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply