Solved

Data validation tool for SQL server 2008

Posted on 2011-03-10
2
647 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 40

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

751 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