Best way to do this is to test the file first usin VBScript in an Active
Script task. Find out the value. You then use workflow to decide where to
go.

Is this "Changing of destination" only valid for one row in a file or do you
need to test each row ?

Same idea just it will be painfully slow.

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org