• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 667
  • Last Modified:

Data validation tool for SQL server 2008

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
gosi75
Asked:
gosi75
2 Solutions
 
rkharkoCommented:
You can use the Red Gate tool - SQL Data Compare

http://www.red-gate.com/products/sql-development/sql-data-compare/
0
 
lcohanDatabase AnalystCommented:
<<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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now