Click here to Skip to main content
15,942,710 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a excel file with having 6 columns, Now I need to validate the value from each cell from each column.
Eg
1.if it is a date column then i need to validate the date format and type
2.If it is a number then i need to validate it is a number or not?

Assume that i have more than 10000 rows in the excel and now i need run the validation process before i import into sql table. If validation fails than rollback the import process.

Suggest me the best way to do this.
Posted
Updated 26-Sep-16 18:22pm

Hi, you have just to click on Excel source right button => input output properties =>Excel dsource output=>output column and then you change Data type
 
Share this answer
 
Hi murugesan.velusamy,

You can do the MAPPING before you transfer the data from excel to the SQL Server thruogh SSIS.
Please refer the below You tube link.

SSIS Validation[^]
Validating Excel in SSIS and Importing [^]
 
Share this answer
 
v2
 
Share this answer
 

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