Menu
Let's add a provider to log information in the SQL tables. Right-click on the control flow area and go to logging again. Select SSIS Log Provider for SQL Server from the drop-down list and click Add. You can use an existing SSIS package connection or use a new connection for SQL Server.
The logging data is stored inside the SSISDB database. This option is only available since SSIS 2012 and up. You can implement your own custom logging. Here, you can use the Execute SQL Tasks for example to write log information to a table.
To configure Error Handling in SSIS, drag and drop another OLE DB destination to store the error output. Next, drag the Red line from Data Conversion (Error Output) to OLE DB Destination 1.
I am working on SQL 2008 - SSIS Package. I am executing the package from C# code. It's 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?
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With