I've created a simple DTS package that exports data from SQL server into a
CSV file... so far so good.

However, I want a non-technical user to be able to kick this process off. Is
there way they can do this without having to go into enterprise mgr?

Thanks

Chris

You can easily create a batch file/VB front end that will run a package.
You need the DTS dlls on the PC that does the running.

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

Execution
(http://www.sqldts.com/default.aspx?104)

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"CJM" <cjmwork (AT) yahoo (DOT) co.uk> wrote

Thanks for that Alan.

I think I'll probably use the ASP solution, or possibly the VB one.

Cheers

Chris

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