Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2003-04-08 : 07:36:06
|
Darlene writes "OS=NTSQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6) I created a DTS package with SQL2000 tools. The package executes fine. When I schedule the package to run and attempt to execute the job, it fails with the error 'The system cannot find the file specified.' I've read KB article 274716 - I haven't edited it with SQL 7.0 tools and I tried saving it with password for owner and user. Same problem. I have jobs running fine on a server with version '7.00.716 (Build 2195: Service Pack 3)' Appreciate any help." |
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-04-08 : 07:55:53
|
Are you trying to import from a file that is not there? Can the Sql server get to the file?Be careful of drive mapping and things of that nature -- always make sure you specify the full UNC path for all files, never use drive letters (except for local drives on the SQL server).- Jeff |
|
|
kbearhome
Starting Member
36 Posts |
Posted - 2003-04-08 : 11:05:59
|
Thanks for your response. I created the package to copy files from one server to another and saved the package. It saved it where ever it saves all the other ones; I didn't give it a path. When I say execute the package, it does. Then I scheduled the package and it saved it where ever it saves the jobs. When I run the job, it fails with the error 'the system cannot find the file specified'. I don't get it - I didn't do anything differently from other jobs that run just fine. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-04-08 : 11:17:04
|
When you manually execute a package the package is looking at your drive mappings. When you schedule the job it then looks at it's own (the servers) mappings. So for example, if you have a file on your C:\ drive, when you run manually, it will find it. I'm guessing that you will need to move the file to the exact location (folders and sub folders ect) to the server.I keep a "mirror" image of my servers mappings on my desktop to "fake out" DTS....Ohhh, but unless I'm dealing with Excel or Access, I dont use DTS anymore. (I'd even make the case of creating csv files from excel and access to avoid using DTS in a production environment).(see Nigels signature)Hope this helps thoughBrett8-) |
|
|
|
|
|