private void AddSQLErrorTask(Executable exe, string TaskName)
{
TaskHost th = exe as TaskHost;
DtsEventHandler thOnError = (DtsEventHandler)th.EventHandlers.Add("OnError");
Executable runSQL = thOnError.Executables.Add(SSISMoniker.SQL_TASK);
CreateEventHandlerSqlTask(runSQL, th.Name + " EventHandler", TaskName, GetConnection(LogConnectionKey));
}
private void ObtainEventHandler(string pEventName)
{
foreach (DtsEventHandler eventHandler in ssisPackage.EventHandlers)
{
if (eventHandler.CreationName == pEventName)
{
onPreExecute = ssisPackage.EventHandlers[pEventName];
}
}
if (onPreExecute == default(DtsEventHandler))
{
onPreExecute = (DtsEventHandler)ssisPackage.EventHandlers.Add(pEventName);
}
}
//internal DtsEventHandler EventHandler { get { return (Executable as DtsEventHandler); } set { } }
#endregion
#region ctor
/// <summary>
/// ctor that takes in a Event Name and the container the event handler should belong to
/// </summary>
/// <param name="eventName"></param>
/// <param name="attachedContainer"></param>
public ISEventHandler(string eventName, ISEventsProvider attachedContainer) : base(eventName, attachedContainer)
{
EventHandler = (Executable as DtsEventHandler);
}
public DtsEventHandlerNodeFactory(DtsEventHandler input)
{
_input=input;
}
public DtsEventHandlerNodeFactory(DtsEventHandler input)
{
_input = input;
}
