Parameters to DTS

Hello,
Is there a way to pass parameters to the DTS package?
For example, we are using DTS to archive data from database into a flat file
every month. Is there a way to pass the name of the file and the
dateFrom/dateTo values to the DTS?
Thanks in advance.
ArsenA million ways
What version SQL Server
2000 look at the /A parameter to DTSRUN
2000 look at a dynamic properties task
7 I like to DataPump to Global Variables and then use the object model
Use the object model to execute the package and pass values to Global
Variables which sets properties of the object model.
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Arsen Vladimirskiy" <arsen@.emergency24.com> wrote in message
news:OST3tdlZDHA.2620@.TK2MSFTNGP09.phx.gbl...
> Hello,
> Is there a way to pass parameters to the DTS package?
> For example, we are using DTS to archive data from database into a flat
file
> every month. Is there a way to pass the name of the file and the
> dateFrom/dateTo values to the DTS?
> Thanks in advance.
> Arsen
>