Approach is provided in the question, This seem to work fine. I'm hoping for some more comments for the question.
For Error Handing, Error Handling can be done by package. All the packages can invoke this package on error. This learning is based on Question in MSDN forum.
Next Learning List
- Passing elements from parent to child package in SSIS
- Desigining the ETL solution for adventureworks DB based on proposed approach
More Reads
Creating a Solid SSIS ETL Solution: Part 1 – Package and Error Logging
Creating a Solid SSIS ETL Solution: Part 1 – Package and Error Logging (cont.)
Creating a Solid SSIS ETL Solution: Part 2 – Package Configurations
Creating a Solid SSIS ETL Solution: Part 3 – Package Template Overview
Creating a Solid SSIS ETL Solution: Part 4 – Email Task and Package Execution Report
SSIS Design Pattern - ETL Instrumentation, Part 1
SSIS Design Pattern - Custom Error HandlingCreating a Solid SSIS ETL Solution: Part 1 – Package and Error Logging
Creating a Solid SSIS ETL Solution: Part 1 – Package and Error Logging (cont.)
Creating a Solid SSIS ETL Solution: Part 2 – Package Configurations
Creating a Solid SSIS ETL Solution: Part 3 – Package Template Overview
Creating a Solid SSIS ETL Solution: Part 4 – Email Task and Package Execution Report
SSIS Design Pattern - ETL Instrumentation, Part 1
Top 10 SQL Server Integration Services Best Practices
SQL Server Integration Services Standards
Faster Extraction & Loading by SSIS
SSIS – Copy file when Exists and Not Locked by another process
Dynamically creating Excel Sheets and populating data from SQL server tables
SSIS: Work Flow vs Stored Procedures
How accurate is your BI information? - Part 1
How accurate is your BI information? - Part 2
How accurate is your BI information? - Part 3
How accurate is your BI information? - Part 4
SSIS Error Handling
Building a Successful ETL Project
Microsoft SQL Server Integration Services Performance Design Patterns
Troubleshooting SSIS Package Performance Issues
Happy Learning!!
No comments:
Post a Comment