Re: DTS transfer from Paradox to SQL Server 2000 using SQL Agent

Hello Johan,


Where are you when you fire the package from EM.? On your PC then you bring the package to your PC, it is not on the server. As a job it is on the server. Could it be that the resources (Driver etc) are on your PC and not on the server?

Allan



Hello Allan,

It's the same account that runs both SQL Server and SQL Agent that
owns the job.

To me it doesn't seem to be a security problem, because everything
else works perfect. Or are there specific security settings in
Microsoft Jet 4.0 or perhaps in the Borland engine that stops the DTS
from executing tasks on the network, when started from SQL Agent?

"Allan Mitchell" wrote:

Hello Johan,

But who owns the job? That could make all the difference.

http://support.microsoft.com/?kbid=269074

Allan

I have a problem when I try to execute some DTS packages from SQL
Agent jobs. The DTS Packages collects data from a Paradox (Borland)
database located locally on the SQL Server machine and inserts the
data in a SQL Server 2000 database. These packages works perfectly
when I Execute them manually in Enterprise Manager. But when I
execute them from a SQL Agent job I receive an error (11265).

SQL Server and SQL Agent are running under the same account with
administrator rights. This is also the same account I use when I
execute the packages manually in Enterprise Manager with successful
results.

I have no problem with other DTS Packages executed from SQL Agent,
just the packages that connects to the Paradox database.

The server runs on Windows Server 2003 sp1.

I hope someone has a solution for this problem.



.

Relevant Pages

  • Re: Very Very Urgent, Please Help
    ... It sounds like you are running the SQL Agent service under the local ... system account which does not have access to the DTS packages. ... System can only access resources on the SQL Server itself) ... having because you can log in under the same account as the SQL Agent and run the packages from Enterprise manager it is often easier to see exactly where your problems are occurring. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Removing a DP
    ... What if I had DPs all across the US and wanted to remove ... you create another server share on ... Delete the shared folder that contains the packages manually. ... > Microsoft Online Partner Support ...
    (microsoft.public.sms.admin)
  • [FLSA-2005:166941] Updated httpd and mod_ssl packages fix two security issues
    ... The Apache HTTP Server is a popular and freely-available Web server. ... A flaw was discovered in Apache httpd where the byterange filter would ... Users of mod_ssl and Apache httpd should update to these errata packages ... where is a list of the RPMs you wish to upgrade. ...
    (Bugtraq)
  • [Full-disclosure] [FLSA-2005:166941] Updated httpd and mod_ssl packages fix two security issues
    ... The Apache HTTP Server is a popular and freely-available Web server. ... A flaw was discovered in Apache httpd where the byterange filter would ... Users of mod_ssl and Apache httpd should update to these errata packages ... where is a list of the RPMs you wish to upgrade. ...
    (Full-Disclosure)
  • [Full-Disclosure] SuSE Security Announcement: samba (SuSE-SA:2003:025)
    ... file server, the widely spread implementation of the SMB protocol. ... Therefore, the update packages ... are being offered to install from the maintenance web. ... standard appendix: authenticity verification, ...
    (Full-Disclosure)