Hi

Is it possible to create a user a interface for a DTS package?

Kind Regards

Rikesh
(W2K-SP3 / SQL2K-SP3)

Ricky wrote:
You got one.
Search for dtsrunui.exe on your machine.

Kind regards

Frank

Hi Frank
Thanks for that, but is there something whereby you can supple parameters or
variables to be used in the DTS?

Kind Regards

Rikesh

"Frank Matthiesen" <fm (AT) xax (DOT) de> wrote

This would be easily done in VB and using the object model with Events to
give you everything you need.


--

----------------------------
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



"Ricky" <rikeshpatel (AT) serviceworks (DOT) co.uk> wrote

In article <#mdE1#5dDHA.2368 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Ricky
<rikeshpatel (AT) serviceworks (DOT) co.uk> writes
DTSRUNUI, click Advanced, here you can set global variable values for
the package. If you want more then you will need to write it yourself as
it means you are tailoring the application to your specific
requirements.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Cheers guys, Thanks for the suggestions, I think I may have to write my own
app in VB?

Thanks again.

Kind regards

Rikesh

"Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in
message news:acqSOYCAM2X$Ewf+@sqldts.com...

In article <uJ#ty8EeDHA.2300 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Ricky
<rikeshpatel (AT) serviceworks (DOT) co.uk> writes
Here is an article on executing DTS from VB, see the download for some
ready built samples-

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


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org