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.
Extreme Catalog Pro is designed to help you maintain and organize a collection of your CD-ROMs, audio CDs, hard disks, removable disks, etc. The program catalogs contents of your media, imports descriptions and thumbnails, and makes it available for offline browsing and searching. Extreme Catalog Pro is ideal to handle your downloaded programs, magazine CD-ROMs or DVD-ROMs, music collections like MP3s or audio CDs, graphics collections, documents and all other types of files.
The basic goal for Extreme Catalog Pro is to provide access to the contents of any media you have from a cataloged database, even if the media itself is not available on the system – you can browse lists of files and folders, search by any criteria, use descriptions, thumbnails, categories, flags, etc.
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.
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.
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.
Recent Comments