data validation tools [Resolved]

Posted by Mrashmi586 under Interview Questions on 2/3/2016 | Points: 10 | Views : 268 | Status : [Member] | Replies : 1
Hi
before loading the data into SSIS we will validate,so for that what data validation tools we will use.please can anyone help on this.
Thanks in advance.

Regards,
-Rashmi




Responses

Posted by: Rajnilari2015 on: 2/3/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
@Mrashmi586 Sir, even after loading the data into SSIS, we can validate and the invalid data can be filtered and pushed into some error table while the processing can go ahead with the valid data. Please read an article ( http://www.codeproject.com/Articles/188075/A-Palindrome-Program-in-SSIS-using-Copy-Column-Der )of mine about the same to grab the concept.

Kindly let us know if that helps.

--
Thanks & Regards,
RNA Team

Mrashmi586, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response