Hey Koen,

Thanks for ur reply. Error Log with Red Flow Direction is working, But unable to Union all Error Logs to handle it in SQL Server Table. Will try that it seems will works fine.

And Package Runs fine, since it as Apt Input file and if any Errors it will surely Blocks. Am new to SSIS and past 3 weeks working in this. Some Transformations will be Blocked in this Package. Please Suggest me to Enhance this Package Better.

I will post my Requirements and Required Output is detail.

1. Flat File (Products [7 to 8 Columns] With Month Names as Columns)

2. Unpivot this Month Column names in Rows and its Value as another column

3. Pivot (In Products there will be a Column Measures - Need to Pivot Measure Column Values to Column names).

4. Products Columns will be Inserted in Product Dimensions.

5. Month Columns in Month dimensions

6. Look-up Product and Month Dimensions in Fact Tables (Those Pivoted Columns will be in Fact Table)

7. And Fact Table Insert.

the above Steps is need to Perform for Each Flat file sources with some Validations.

Validations:

1. Any New Product Dimensions (Have to Pop-up those Values)

2. Any new Month Dimensions (Have to Pop-up)

3. Any Duplicates or Null Values (have to pop-up)

4. All those Transformations with Errors need to Capture it in SQL Server Table.