Hi Guys, Is there a way to configure the DataFlow Path using expression inside the DataFlow? Because i have a requirement if the date is not from yesterday the process should stop and send an error. Thanks,

Another thing, I will set up a Conditional Split Transformation to split my data in Good Data and Bad Data. The Bad Data will be written to a text file and result in a "failed" Data Flow Task. The Control Flow will then initiate a File System Task to email the text file when the Data Flow Task fails. My question is how do I configure the Conditional Split Transformation such that when a row is written to the Bad Data output the Data Flow is considered to have failed thus triggering the File System Task in the Control Flow?

Wookies, FOr your first question: You need to evaluate the date value earlier in the process at the control flow level. You can capture the date value in a SSIS variable and the use expression in the precedence constraints (arrows linking tasks in control flow). You need to create an expression in such a way that the data flow is only executed when the date value is the expected one. You can use an approach similar to this one: http://www.rafael-salas.com/2007/02/ssis-loop-through-files-in-date-range.html For your second question: I would use a row count transformation to count the 'bad' rows. That way, once the data flow is completed you can put conditional logic in the control flow based on the value of the variable holding the row count.Help Others! Don't forget to mark your thread as answered

Done it, Thank you Rafael.