SSIS 使用EventHandler处理错误 Error Handling using Event Handler

Categories: Database; Tagged with: ETL • SSIS; @ October 29th, 2012 12:02

需求：

某组件/package发生错误时进行发送邮件/通知等响应操作

解决：

1. 配置组件/package： 必要时配置FailPackageOnFailure = true/ FailParemtnOnFailure=true；

2. 创建Handler：切换到EventHandlers 页面， 选择Handler的执行范围，拖拉控件进行设计。

SSIS Difference between OLE DB Source & DataReader Source, OLE DB Destination & SQL Server Destination <-> Using Transaction in SSIS

---

ActionScript Adobe AIR ANT Apache ApacheFlex Apache Flex Better Developer BlazeDS Cloud Computing CMD DataGrid DataGridColumn DB2 Derby DTSX Eclipse ETL Event Excel Flash Builder Flex Google Java JDBC JDK JIRA Life@SG|新加坡 Linux MySQL Oracle PHP Python RegEx Servlet SQL SQL Server SSIS SVN T-SQL Tools Tree Ugly WordPress XML dev-notes side-projects