Hello:

I have an Access 2k database that I am using as reporting
tool. I need to pass some parameters to a DTS package
via a form in my database.

Several people in this forum have informed me that the I
need to use the ? placeholder and a parameters button to
accomplish this. I understand the function of the
placeholder but I cannot find any info on a "parameters
button" Is this a special type of control within
Access. Where do I find it and how is it used?

Any information on this subject will be appreciated

Thanks
Brennan

The parameters button is a feature of the DTS GUI as is the ? placeholder
(in this case anyway).

If you are using Access then are you using the DTS object model?

You can easily pass values using the object model to the package after
retrieving it and before execution.

--
--

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


"Brennan" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Please excuse my ignorance but where in the GUI would I
find it? I'm using SQL Server 2000 enterprise edition
and for the life of me I can't find a Parameters button
in the DTS window.

Also, how do I add the dts object model to my Access
database? Is there any good documentation on this issue?

Thanks for your patience

Brennan

OK

1. The parameters button can be found on the

ExecuteSQL task, The DataPump Task, Data Driven Query Task

2. Add a reference to the DTSpackage object library

You can then use a variation on this article to call and execute a package

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208)

--
--

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


<anonymous (AT) discussions (DOT) microsoft.com> wrote