Solved

SQL Server 7.0 Package error

Posted on 2002-04-26
4
154 Views
Last Modified: 2013-11-30
I am running SQL Server 7.0 on NT 4.0. When I try to schedule a job on the server it gives me the following error:

Package error
Error Source: Microsoft Data Transformation Services(DTS) Package
Error Description: The system cannot find the file specified.

 But I can run a job on a client machine no problem. The old scheduled jobs run fine too. Has anybody had this problem before? Any help would do.
0
Comment
Question by:shamif
4 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 100 total points
ID: 6972337
It is accessing a file which the server does not have access to.  In other words, supposing you have tested successfully importing a text file from your workstation.  That text file maybe on your local drive or mapped in such a way that the server cannot "see" it.

More details maybe helpful.

Also, please maintain your open questions:
Questions Asked 4
Last 10 Grades Given  
Question Grading Record 0 Answers Graded / 0 Answers Received

Thanks,
Anthony
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 6972558
listening
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7670304
Hi shamif,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept acperkins@devx's comment(s) as an answer.

shamif, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Computer101
ID: 8092630
Comment from expert accepted as answer

Computer101
E-E Admin
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question