Hi All, I am developing a package which loads the data from a flat file into a destination table. In this package I am using a Look up task to allow only the matched rows into the destination. The unmatched output will be redirected to a flat file. Now I am stuck up after this step. I also need to validate the data before loading it into the destination table. Say if i have 6 columns in my destination table , for ex a date column- I need to validate that it is a proper date and then I need to load it into the destination. If the date is not valid then I need to redirect this row to a error file. Similarly for a integer column if i get a string inplace I need to redirect the row to the error file. How will I achieve this? From my initial analysis I feel we need to use a conditional split (CS). But if there are 6 columns then I need to use CS task for each column to validate. Is there a better way of handling this? Please let me know if anything is not clear or if you require additional info. Thanks, RamPlease vote as helpful or mark as answer, if it helps

you have to do lookup for the validations. Regards, Eshwar.

Hi Eshwar, Thanks a lot for the reply. When I mean to say a valid date means if the date format is valid or not (YYYY-MM-DD-hh:mm:ss). I dont want the value of the date to be looked up. Regards, RamPlease vote as helpful or mark as answer, if it helps

Hi Ram, What tools for data cleansing you have?Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

Hi Raunak, Thanks a lot for the reply. We are using SSIS 2008. Regards, RamPlease vote as helpful or mark as answer, if it helps

Ram , this is data cleansing we are talking about. I suggest, you load the data in the staging and later apply update queries to alter data. This should happen before you place any SSIS transformation to the packagePlease vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

If you had DQS(Data Quality Services) installed, this task would have been very intiutive.Please vote as helpful or mark as answer, if it helps Cheers, Raunak | t: @raunakjhawar | My Blog

I would do this in a script component. That way you only have one task to do all the data cleansing and only one error output. .NET has some powerful functions that can check for data validation.MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...

I would do this in a script component. That way you only have one task to do all the data cleansing and only one error output. .NET has some powerful functions that can check for data validation.MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...