Following steps need to follow to test data loading
* Source data should be known
* Target data should be known
* Compatibility of source and target should be checked
* In SQL Enterprise manager, run the DTS package after opening the corresponding DTS package
* You have to compare the columns of target and data source
* Number of rows of target and source should be checked
* After updating data in the source, check whether the changes appears in the target or not.
* Check NULLs and junk characters
