Categories
BI

Rollback in Data Import Task–SSIS

I was working in a package and I was requested to set the import task as transaction consistent. In SSIS you can do all sorts of ETL stuff so when you import data you need to make sure the import is in consistent state which means either all the data should gets loaded or it should be rolled back to the previous state. You can enable this option either in package level or container level or at task level. Based on your requirement you can set the transaction property so the final output is in consistent state.

Categories
DBA Reporting Services

Ten Minutes to configure Reporting Services 2008

In my previous webcast we have seen how to install reporting services 2008. Here is my next webcast on configuring reporting services 2008.