How to validate the datatypes and error message in SSIS package???

  • 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

  • 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

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply