June 22, 2010 at 8:27 pm
I have these SSIS 2008 packages that was converted from DTS 2000 which load data from oracle databases into SQL Server. When the connection to the oracle database goes down because we us a mirco wave link some time for a few seconds but other time longer.
The sql server validates package connection and if no connection exists than the package does not execute. I was wondering how I can check the connection status and email me an error message.
June 23, 2010 at 9:43 am
How are you executing the package? Also was it a true conversion or do you have a bunch of EXEC DTS 2000 tasks?
you might consider setting the DelayValidation to TRUE for the package.
CEWII
June 23, 2010 at 3:36 pm
The packages have no SQL Server 2000 legacy function or components, they have been converted to 2008.
The packages are save on to SQL Server 2008, run by SQL Server Agent, a job schedule package is set to run over night.
June 23, 2010 at 3:40 pm
Ok, all of that sounds good.
Well you could add a step near the beginning of the package that uses an EXEC SQL task to do some noop command against the remote location, like SELECT 1=0, and if that fails send an email, if successful go on to the rest of the package. This is if I understood what you were asking for..
CEWII
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply