Excel into Temp table and validations in SSIS
| i have an excel sheet with about 30 columns of data ...i want to validate all the data in these cells of the excel through SSIS. I want to get this data to a temporary table before running my validation stored proc...how do i get this data from the excel to the temp table , this temp table should accept all the data from the excel file in whatever form it is there should be no rows that get discarded while filling this table from the excel. Moreever how do i get the column header data if the first row in the excel contains Column names how do i get these names and validate them if they are conferring to a set of names. Excel sheet :: ColName1 ColName 2 ........ColName30 ColData11 ColData12..........ColData130 .....
Also can i do validations like Datatype and Length directly in SSIS ? or do i need to do it with a stored proc Please Help.... Thanks |
[1567 byte] By [Clayton_drd] at [2007-12-16] 