Solved

Data validation tool for SQL server 2008

Posted on 2011-03-10
2
642 Views
Last Modified: 2012-05-11
I'm trying to find a good data validation tool for my SSIS packages, that is, I need some validation tool that can check if the data in the source system are correct compared to my OLAP DB after each exectution of the SSIS package ?

Can anyone recommend a good tool to do that?
0
Comment
Question by:gosi75
2 Comments
 
LVL 3

Accepted Solution

by:
rkharko earned 250 total points
ID: 35094974
You can use the Red Gate tool - SQL Data Compare

http://www.red-gate.com/products/sql-development/sql-data-compare/
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 250 total points
ID: 35095214
<<I need some validation tool that can check if the data in the source system are correct compared to my OLAP DB after each exectution of the SSIS package >>

"data in the source system" must be always correct as the OLAP dabatase should be always populated from OLTP database and not viceversa. Also in my opinion whatever SSIS you run to populate your OLAP db should only READ source OLTP database and not alter it for any reason.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now