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!

Invariably this has to do with a permissions issue. The error 80004005
tells me either "Access Denied" or "I can't find what you requested"

Have look at this

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Dominic Feron" <dominic.feron (AT) dessausoprin (DOT) com> wrote

Thx for the info! I'll look with the system administrator about this
article.

One thing I've noticed is the DTS doesn't seem to work on any computer with
the OS Microsoft Server 2000 installed on.

I did a non-scheduled test on 2 other server, and I got the same error as if
I was trying to schedule the DTS task on the real server.

Is it possible that it could be an OS issue?



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> a écrit dans le message de
news:%23RxBML6aFHA.3808 (AT) TK2MSFTNGP14 (DOT) phx.gbl...