Re: DTS Deployment Across Several User PC: Stuffed Up!

#1

MDAC will give you the connectivity (Access permissions allowing)
Using this article will allow your users to Execute DTS packages.

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

--

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

"Dip" <Dip (AT) Microhaus (DOT) com> wrote

Quote:

Hi Experts,

I have an application designed on MS Access 97 utilising forms and
queries. The appplication is soucing data from a centralised SQL Server
Database. I also have several DTS packages that need be run from the
application. This is happenig as it was expected.

Now, how do I deploy this appplication to severeal client PC so that
users can use this application with their network login?

1) I would install SQL Server client access to those PCs

2) I will create the ODBC connection to each of those PCs

Then what am I supposed to do?

Can any one please help me??

Thanks.

Dip

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS Deployment Across Several User PC: Stuffed Up!

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS Deployment Across Several User PC: Stuffed Up! - 10-14-2003 , 01:27 AM