Hi.. I have a excel destinantion in the Dataflow task. Before inserting into the destination i am using row count and storing in a variable. Now..if the varaible has count > 0 i want the package to be failed or raise an error. Please help me..how can i do this. Can i able to do this in dataflow task or control flow ?

You can use a script task in the control flow to check the value of the variable, and raise an error. See this link for some sample code on how to do this: http://msdn.microsoft.com/en-us/library/ms136054.aspxJohn Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com