The Design time is less than forgiving and not as strong as the runtime so
when I encounter things like this with the ? place holder I usually build
the statement bedore the task and assign.
Global Variables and SQL statements in DTS
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know