[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server 7.0 Package error

Posted on 2002-04-26
4
Medium Priority
?
164 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 400 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 101

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Viewers will learn how the fundamental information of how to create a table.
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.
Suggested Courses

834 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