Maybe this article will be of help:
http://www.sqldts.com/?246
--
Jacco Schalkwijk
SQL Server MVP
"Peter Newman" <PeterNewman (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have a DTS set up to inport files from a specific directory using a DDQ
Task. Is there a way to set the task's 'Table/View' property from a Global
variable. ive been trying to use a Dynamic propertied task, but i keep
getting a faluire stating the file was not found, yet if i re run it it
loops round 1 cycle fine.
I was thinking of using an Activex task to set the names ?? |