Post reply

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

  • July 6, 2009 at 7:14 am

    #133661

    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

    #1020859

    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).

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

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