Sending Success AND/OR Error file to a table

  • Here I have a simple problem but need to get some help on it. I will be getting 4 source files(pipe delimited flat files) from FTP server everyday and then I must compare if it matches the datatype that I have in my database table. If it is the same, I will have to send 4 success file to a table. If even one of it does not match but 3 other is okay, I will have to send 3 Success file and one Error file. I have already created a table called 1.Success 2. Error

    For the error file, lets say only one column has mismatching of datatype, I need to send back the whole row with that mistake ( i am assuming SSIS will give some kind of error code with that) to the error table

    Can someone walk me thru of the steps and what ALL transformations are to be used. Really in need of help.

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • Forgot to add that if everything matches and when the success file goes, those source flatfiles will enter my Database table. I know how to do this but just wanted to make sure nobody gets confused about what I am trying to do here...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

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

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