Hi there...

I'm trying to extract from a Sybase SQL Anywhere 5.0 database, and dump it
into a table on the MSSQL server. It works perfectly when I activate the DTS
package, directly on the server, but if I use a vbscript to do so, it fails
to start up the client program, which is needed for Sybase connection.

How do I get DTS to start up the client program when the package is remotely
activated?

--
I doubt, therefore I might be.

do you strts your package under a valid NT user?
if you start through a service, generally a service run under the system
account, like the SQL Serve agent, so change the account to use a valid user
account which can access local and remote ressources.


"Kim Noer" <kn (AT) nospam (DOT) dk> a écrit dans le message de news:
u4%23CbJBlEHA.3968 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

DTS packages execute on the client. This of course depends on how you
exceute the package, but if using VBScript and teh object model to call
LoadFromSQLServer then the package executes on machine which you run the
VBScript on, and under the crededntials of the user who started the
VBScript.

So does that local machine have the correct drivers installed, and does the
executing user have permissions.


--
Darren Green
http://www.sqldts.com
"Kim Noer" <kn (AT) nospam (DOT) dk> wrote

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote in
message news:u5XFd2ClEHA.1652 (AT) TK2MSFTNGP09 (DOT) phx.gbl
Actually it is LoadFromSQLServer I'm using to start the packages - but I was
hoping that the packages ran on the server, and all the client did was just
asking for that.

So that's what I want - I want to be able to have a vbscript on the client
machines, which executes the packages on the server. Currently I've found a
way by using psexec - but I would really like to have it all in the script.
Is that possible?

Yes of course - I completely forgot about that.

--
I doubt, therefore I might be.