July 6, 2009 at 7:14 am
Hi
I have a 2 excel files which is predefined with 10 columns.I will acess those two files in for each loop which will process the data file by file.
Now i need to check the datatypes of the file.i.e if any Numbered column which i m expecting but i m getting the text in this case i need to fail the package and need to capture the error message saying that the data type mismatch for the perticular column.
Is it possible in SSIS??
Plz help me out ASAP
Thanks in Advance
July 6, 2009 at 10:00 pm
There is no function which will look at a column of data and return you an appropriate datatype. This is something which Excel tries to do when it opens a CSV file and often does the 'wrong' thing - it's not easy.
If you feed your data through a Script Component within a dataflow, you will be able to redirect 'invalid' (based on your criteria) rows to a different output (and, from there, to a log file perhaps).
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply