• I would use a conditional split.

    http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx

    http://msdn.microsoft.com/en-us/library/ms137886.aspx

    Basically if a column has the value you expect then send it to the main output. Otherwise send to your error.

    Russel Loski, MCSE Business Intelligence, Data Platform