test dataflow in SSIS package

  • How would you test the data flow transformations in SSIS package.Other then using SSISUnit which only works at the control flow level.

    or How can we test a SSIS package.That the data loaded in our target databse is correct.

    thank you

  • I recall one of Brad McGehee's tip mentioned about tablediff (Replication Diff) tool located at [C:\Program Files\Microsoft SQL Server\90\COM] - change 90 to whatever version appropriate...

    he mentioned that tool is useful in the event one wishes to check the difference between the source and destination data in the replication process...

    I tried that tool without the standard replication process involving publisher/subscriber model. By that I mean, I had copied data using some ssis package. That tool can tell us whether source and destination data is the same or not... is this what you are looking for?

    if this is the tool you're looking for then follow these steps:

    1. use script component tool to run the tablediff tool

    2. use the -o flag to specify an output file

    3. check whether the output files says identical on each table

    lastly, good luck!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply