Could I get some info about package architecture and features?

Jan 9, 2014 at 11:48 AM

What is an idea behind your package?
Is it possible to save log data into the table?
How you save the data during rollback?

Thank you for your work!
Apr 29, 2015 at 12:24 PM
Edited Apr 29, 2015 at 12:25 PM
Very sorry about my late reply! I am in a different long-term project and not working much with MS SQL Server at the moment, therefore I did not find time to continue this project! This is why I marked this project as discontinued now.

Regarding your question: Yes, you can save business data (such as Tracking-ID's for reference, etc.) in your logging-message. It is not being rollback'd since you use a Table-Variable instead of a real table. The content of the Table-Variable is being saved outside your transations. Therefore, transaction log does not apply and nothing will be rolled back.

Sincerely, Daniel Pavic