DTS error when the task is scheduled on the server!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello everyone,

I was asked to create some DTS package that transfer data from a Foxpro
database to SQL Server,

Everything works fine when I execute the task on my local machine but when I
schedule the task on the server, I get this error message :


"Executed as user: *******. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: Copy Data from listfour to
[NetsipDesign].[dbo].[DSQ01_Fournisseur] Step DTSRun OnError: Copy Data
from listfour to [NetsipDesign].[dbo].[DSQ01_Fournisseur] Step, Error
= -2147467259 (80004005) Error string: [Microsoft][ODBC Driver
Manager] Driver does not support this function Error source: Microsoft
OLE DB Provider for ODBC Drivers Help file: Help context: 0
Error Detail Records: Error: -2147467259 (80004005); Provider Error:
0 (0) Error string: [Microsoft][ODBC Driver Manager] Driver does not
support this function Error source: Microsoft OLE DB Provider for ODBC
Drivers Help file: Help context: 0 DTSRun OnFinish: Copy
Data from listfour to [NetsipDesign].[dbo].[DSQ01_Fournisseur] Step
DTSRun: Package execution complete. Process Exit Code 1. The step
failed."


I thought this line was the key to get over this problem ("Error string:
[Microsoft][ODBC Driver Manager] Driver does not support this function") but
I've looked at the drivers I have on my PC and compared it to the one on the
server and they are exacly the same.

Anyone ever experienced this kind of problem?

Thx for your help!


.

Relevant Pages

  • Re: File Upload - Security Issues
    ... uploaded and the user could upload any or all of these in theory. ... There is no one product that can give you 100% security, ... > Code doesn't execute in local memory space unless remote user has rights ... > You don't have MS Office installed on the server. ...
    (microsoft.public.scripting.vbscript)
  • Re: System.Security.SecurityException was unhandled
    ... Is it a must that I need to register the COM server to the machine using ... CAS permissions on the client machine, and the COM issue is a new problem. ... assembly actually has the permission in question. ... When I execute the application I received and error message. ...
    (microsoft.public.dotnet.security)
  • 2nd Post - Trouble Getting VS.Net 2003 WalkThrough working
    ... the server. ... MSDE either from the Setup or from the SQL2KDeskSP3 execute. ... it does look like some of the sample databases have been ... >> and they directed me to install MSDE and they attached a ConfigSamples ...
    (microsoft.public.sqlserver.msde)
  • Re: How to launch a Windows application from a ASP.Net web applica
    ... It can execute Java, ActiveX, and JavaScript, and maybe a few other things. ... The only reason your program has been somewhat successful is because your client and server are on the same machine. ... programs I knew how to create a batch file program already. ... When using ClickOnce it creates/deploys the Windows application from ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: IIS 6.0 on Windows Server 2003
    ... If PHP insists on using CMD.EXE to execute the shellcommand on the ... server, then no, you have no choice -- you must give read permissions to the ... this would be a security vulnerability caused by PHP. ...
    (microsoft.public.inetserver.misc)