Click here to Skip to main content
15,886,724 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
I'm currently importing data from flatfile to crm database using C# script component in ssis package.
i now need to do data validation for the data like
1) To check whether the attribute is required field in crm.
2) To check whether the attribute is taking correct datatype,
3) To check the length and max,Min size of the Text type Attribute,
4) To check lookup and picklist type attributes were referring to correct schema.
all this i need them to be validated in ssis script component using C# code.
i'm very new to such data validations.
if any one guides me or helps me,i can learn a lot and it would be helpful for me.

What I have tried:

i tried to do data validation using data conversion transformation and and data profiling task and later came to know that is not the exact way to do it and it should be in c# code.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900