March 6, 2009 at 4:05 am
I have a SSIS package and I need to schedule that at 2 AM everyday.With this SSIS package I will connect to Oracle database to fetch the data.Here the Oracle database will be in restricted mode due to refreshment at the same time.So I need to put some check in my SSIS , so that it will go and see if the login to oracle is successful or not.If successful, then it will go to oracle and fetch the data.
If not successful then it will sleep for 3 mins and again go and the check the database status till one successful hit.
Is there any way to achieve this with the help of SSIS?
Thanks in advance
March 6, 2009 at 5:32 am
Yes.
Use a for loop container and put an execute SQL task in it. Have the Execute SQL task return something to a variable if it is successful. Set this task to delay validation. Have your for loop break when the variable is set to the value returned by the execute SQL task. On failure of the execute SQL task, either use a script task or another execute SQL task with a WAITFOR to have the process wait for 3 minutes before checking again.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply