data validation tools [Resolved]

Posted by Mrashmi586 under Interview Questions on 2/3/2016 | Points: 10 | Views : 2503 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	@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

@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

Latest Posts