I have just tried to do this and whilst you can call a Function in the
Lookup it would seem if you parameterise the function as in your case then
it does not work.

A usual work around is to provide the same MetaData to the lookup in the
designer but then go to the disconnected edit setup and edit the statement
to the one you want. Even this does not seem to work though.

Can you not incorporate the function into the SELECT statement as the source
of the datapump.?

--

----------------------------

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


"Oleer" <anonymous (AT) discussions (DOT) microsoft.com> wrote

thanks for your response

I'm going to try another way