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 - 2001-11-09 : 14:35:42
|
| Derek writes "Help!! I have only been working with DTS and Packages for a short time but I am having an error that I cannot resolve. I searched the archives and still have no answer. I have a new package that I created that migrates data from DBase III to SQL Server. On my development box, the transformations work without errors. When I create the same package on the server (on a completely seperate network) I get the error: "The process could not be created for step 1 of job 0x304B8834FF0218468E8000847D814E62 (reason: The system cannot find the file specified). The step failed."I am not using mapped drives on the server, nor am I connecting to the server using Enterprise Manager, I am connected via Terminal Server and created the package new. To determine if the error was based on file or directory permissions, I created a new package that merely deletes nulls from an existing table. I can run this in the Designer all day, no errors. Once I create a package and Start the job, same error so, now I know it is not specifically related to the file I am trying to import. I am really searching for ANY ideas right now. I was going to upgrade SQL 2000 to SP1, but dont want to unless it is required for this. Error: DTS Scheduled Package FailureDatabase: SQL Server 2000 Server: Win 2000 Server, SP2Derek" |
|
|
|
|
|
DTS Package: The system cannot find the file specified