I'm creating a new connection in the dts designer, I set the
"data source:" as "textfile (source)."

What I'm trying to do is insert a variable in the "file name:"
text field, so that when one runs dtsrunui.exe at the command
prompt one can pass in the filename in question to dts, which
will insert it into the "file name:" text field.

I've been toying around with using a global variable to do this,
but coming up empty. Any ideas or suggestions?

Thanks!

n/m
Similar thread below.

news:2jbqceF106opqU1 (AT) uni-berlin (DOT) de...

You need to think about it differently.

Use a Dynamic Propertries task to assign a Global Variable value to the
DataSource Property of your Text file. Now make sure this DP task goes
first in the package

--
--

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


"DaCount" <roy.andersonREMOVE (AT) gmail (DOT) com> wrote