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.