Solved

Data validation tool for SQL server 2008

Posted on 2011-03-10
2
646 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

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…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.

828 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