I am working on SQL 2008 - SSIS Package. I am executing the package from C# Code. Its simple Flat File ( .csv) to SQL Table.
From the c# code, i get execution result as "SUCCESS". But inside the package Transactions have not taken, So values are not actually exported.
I need to debug it, by reading the log file.
How to create Error Log or Log File inside the Package. ??