Log Failed SQL Server Connections

Last Post 02 Jan 2009 04:57 AM by Amber_Robertsona. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Amber_Robertsona
New Member
New Member

--
02 Jan 2009 04:57 AM
Dear All, I have an SSIS package which connects to each SQL Server I have listed in a table. I would like to be able to log the name of the SQL Server the package failed to connect to. I have been looking at Event Handlers but not sure how I would capture the name of the SQL server as the Source OLE DB connection SQL Server name is supplied via this table. Let me know if you want more details.

Any suggestions much appreciated.

Kind Regards
Amber


Acceptable Use Policy
---