Created two Control flow Tasks for Dimensions and Fact Tables Load. Each Control Flow Tasks as some Data Flows (Flat File Source, Pivot, Unpivot, Multicast, Sorting, Aggregation, Dimension Table Lookup, Fact Table Lookup, Data Conversion, OLEDB Destination etc...)
Works fine with above Transformations. Need some Help to Handle Events for Data Flow Tasks with Error Handling. All these Data Flow Tasks and Error should be Tracked in SQL Server Table.
And How to Show a Pop-up for Input from User to get his emailID and to store the EmailID with Data Flow Tasks in SQL Table.
Attached Screen shot of my Package created so far....