SSIS data validation?

Posted by Sivanagamahesh under MSBI (SSIS, SSRS, SSAS) on 12/11/2017 | Points: 10 | Views : 270 | Status : [Member] | Replies : 0
I have a json document that accompanies around 125 segments and I have to stack it to a DB Table.I'm utilizing http://kosmiktechnologies.com/msbi-training-in-hyderbad/]SSIS bundle and subsequent to dumping all the JSON record substance to a DB DUMP Table,I need to approve the information and load just the information that is substantial to the MASTER Table and Send the rest to a disappointment table.The disappointment Table has 250 sections with ERROR for each column.If the primary segment comes up short validation,I need to compose the mistake message to the comparing blunder segment and proceed with the approval of second column...Is there some utility IN SSIS that aides in accomplishing the necessity.

I've taken a stab at utilizing Conditional Split however seems as it doesn't possess all the necessary qualities.. Much appreciated.




Responses

(No response found.)

Login to post response