Solved

Data validation tool for SQL server 2008

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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

867 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

12 Experts available now in Live!

Get 1:1 Help Now