Hi.

I am creating a DTS package that has a number of tasks. The primary purpose
of this DTS is to import and process data from local delimited file.

I have a data source connection that wraps the source file content and
allows the system to see it as just another database.

Right now the path to the local files are hardcode. I would like them to be
dynamic. Is there any way to parameterize the DTS so that I can simply pass
information just as file paths into the package.

Peter Rilling wrote:
Look at using the Dynamic Properties task to read from a location and
assign the property. If you need to manipulate the values then use an
ActiveX Script Task.

Another good way of passing data into a package is to use global
variables, which can be set through the /A parameter for DTSRUN.

This may be of use-

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

--
Darren
http://www.sqldts.com
http://www.sqlis.com

Will this also allow me to change the source location of a text file
connection? I want to specify the location at runtime but the Sql designer
requires a file path.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Sorry, did not read you message completely. I will look at that link,
thanks.

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Hi,

The global parameters can be mapped to properties of your connection tasks.
At design time a file must exist in order to save any changes to the
connection task
but as specified the global parameter mapping will take over when it's run.

Bye,
Peter
"Peter Rilling" <peter (AT) nospam (DOT) rilling.net> wrote