June 21, 2011 at 4:04 pm
Hi !
I am running a query in around 100 oracle databases from BIDS(Visual Studio) .and if any error occurs at any database connection i need to track out the error message in a flat file or in any form for that connection, with oracle database name and the reason for failure . Can any one help me in regard to this ??? thanks in advance .
June 22, 2011 at 8:55 am
Yes there are certainly ways. SSIS error handling and logging is robust but I have found the bar to be high to get a simple solution in place...which I guess could make it not-so-simple. Books Online and Google will not let you down. Maybe someone else will provide some links. Sorry, but it's a big topic.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 23, 2011 at 6:09 pm
When you say from BIDS/VS - I assume you mean SSIS? You should be able to use simple SSIS logging for this, and that can be stored in a flat file or a database table. You can set which events to log, so you could log "On Error" if something fails due to a connection. Is this on the path to what you were looking for?
June 24, 2011 at 2:04 am
And here's a link: http://msdn.microsoft.com/en-us/library/ms167456.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply