Remove duplicates from SQL Server Databases.

go to DoubleR Software home page
go back
RSS Icon View all RSS Feeds - Software News
Keep Informed - Subscribe now!
Didn't find what your looking for?
Try our search tool:
Business Software News RSS Feed:
Add to Google Reader or Homepage

SSIS package to detect and remove only duplicate data (rows) in your SQL Server.

Quick jump to other category on Windows software
separator




Related Software


Remove duplicates from SQL Server Databases.
SSIS Remove redundancy 1.0 by SQL Lion
License: Free
Popularity:
3% popularity: SSIS Remove redundancy
This software was not yet scanned for viruses


Publisher's description

Here comes one more challenging yet interesting topic to tide over. The requirement goes something like this: You have some sources, let it be some sales data or some Call center data coming from different sources. Data can be of different media. But you are able to load it in your staging tables i.e. one staging database you are maintaining like StageDB for storing these incremental data.

So, here we have both master i.e. Dimensional data and Detail i.e. Fact data in our stage database. But before processing further and loading it into our Mart or Data warehouse, we need to check if there is any redundancy at the row level for each of these tables in the staging database. Here comes the main problem, what if you don't know how many tables are there in the staging database and how many columns are there for each table in the staging database but still you have to keep only unique records for each table.


This means there must be some mechanism to deal with this problem dynamically, i.e.

It has to detect the number of tables for the StageDB database.
It has to detect all the columns for each table in the StageDB database.
It has to detect only the redundant records for each table in the StageDB database.




Size: 4KB
Cost: $0.00


Rate this program:
0 Out of 5
Rated by 0 users.
12345

What do you
think about
SSIS Remove redundancy?
Add your comment



What's New in this Release: -- Detect the number of tables for the given database. -- Detect all the columns for each table in the given database. -- Detect only the redundant records for each table in the given database.
Platform: WinXP,WinVista,Win7 x32,Win7 x64,Win2000,Windows2000,Windows2003,Windows Vista U
License: Free
Category: Business::Databases & Tools
Date Added: Aug 23, 2010
Last check for an update: Dec 05, 2016
Last version date: Apr 18, 2010
Downloads Total : 2
Downloads last 10 Days: None
Page Visit: 153
Malware Status: Not scanned yet

Link to SSIS Remove redundancy sample code
SSIS package to detect and remove only duplicate data (rows) in your SQL Server.



SQL Lion Products:


Let others know your opinion about SSIS Remove redundancy! Add your comments:

No comments have been provided.


credits


Your Name:

Your Location:

Your Comments:

Security check *

 


Disclaimer: DoubleR Software Download is not responsible for the content of the publisher's description or website. We cannot be held liable for issues that arise from the download or use of these products. We take every care to ensure that software available from this site is adware-spyware-virus-free but any software downloaded should be virus-checked by the downloader.