Is there a way for a Web interface to execute a DTS package and pass a
parameter to the package?

Do you mean like this

Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207)

--
--

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


<imani_technology_spam (AT) yahoo (DOT) com> wrote

This is good. What about passing parameters into the DTS package?
Let's say the user enters parameters into an ASP "form." How does
that get into the DTS package?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

You can have in your package the parameterised parts be assigned through
Global Variables. Using the object model in your ASP code you can assign
values to those Global Variables before you do .Execute



--

----------------------------

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


<imani_technology_spam (AT) yahoo (DOT) com> wrote