
Here comes the real deal, sometimes you may face some unexpected things happening in SQL Server while creating SSIS package or dealing with the same, like missing Foreach File Enumerator or Foreach Item Enumerator in Foreach loop container. You might be thinking that, maybe it is not available in my piece of software.
Read more…
Cleaned and error free data; this is the common phrase that we normally listen from most of the data warehouse users. So to make this statement true, SQL Lion team has come up with a tool named “Duplicate Remover“.
This tool will search for the presence of duplicate records (redundancy in tables at record level) as per the selected databases and tables from SQL Server instance, and list them. After checking the redundant tables, the user can customize the delete operations to limit the deletion to certain tables.
Read more…
In the world of data warehousing, SQL Server Integration Service (SSIS) is a popular platform for building high performance data integration solutions including Extraction, Transformation and Load (ETL) packages for data warehousing.

But programming Integration Service has become more popular in between SSIS developers recently. So to help SSIS developers for boosting their programming abilities, SQL Lion team has come up with a unique tool called “SSIS Component Explorer”. This tool can be used as a Swiss Army Knife, to hunt down critical problems while developing SSIS package programmatically.
Read more…
SSIS provides a unique feature to track the execution of the packages so that it can be utilized for debugging or analyzing performance later. Here the application provides an ultimate way to set the logging features of the packages batch wise i.e. set log features to all the packages at a time.
Read more…
Recent Comments