Re: Remotely activating DTS - ODBC 'client program' fails to start?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jéjé (willgart_at_BBBhotmailAAA.com)
Date: 09/06/04 

Date: Mon, 6 Sep 2004 09:56:05 -0400

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@nospam.dk> a écrit dans le message de news:
u4%23CbJBlEHA.3968@TK2MSFTNGP11.phx.gbl...
> 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.
>
>

Relevant Pages

  • Re: Error running DTS package on a schedule (only!)
    ... > | When I try to schedule a job for this DTS package under SQL Server Agent ... > security connection is made using the account you used to start SQL Agent ...
    (microsoft.public.sqlserver.dts)
  • Re: Jobs Failed do not work when scheduled done via DTS Scheduled Package
    ... the SQL info out within the PATH. ... running one of the Jobs and it executed without a hitch. ... > What does the DTS package do? ... the account used is whatever account you ...
    (microsoft.public.sqlserver.server)
  • Re: DTS runs fine - SSIS fails! Why?
    ... Your job is running under computer account, ... We upgraded to SQL 2005 and loaded the 2000 DTS components. ... SQL Server Integration Services Package ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS not running as scheduled job
    ... from certain tables in one SQL db to another server. ... drives are being used. ... Both services are using the same account. ... >> I have a DTS package that I can run manually without any problem but when I ...
    (microsoft.public.sqlserver.server)
  • RE: OSD Image Deployment via SMS advertisement (cannot connect to
    ... I rebuilt my test machine, advertised my package to it, and it's now ... showing the new software account as the username when trying to deploy the ... put in the advanced client network access account field. ... OS Deployment advertisement failed to install OS Deployment agent!. ...
    (microsoft.public.sms.swdist)