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 |
|
danielmeresa
Starting Member
10 Posts |
 Posted - 2007-08-31 : 11:06:42
|
| When launching any dts package in the designer an error "The system cannot find the file specified." is being shown. If I click OK I see the connection objects, but none of the task objects show. I installed SQL 2000 Server Developer Ed and have SQL 2K SP 4.Any help would be GREATLY appreciated. Thanks,Daniel |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 16:23:01
|
| Can you create new package? |
 |
|
|
danielmeresa
Starting Member
10 Posts |
Posted - 2007-08-31 : 16:57:45
|
| no, it I can't it shows "The system cannot find the file specified" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 18:08:11
|
| Looks like dts related dll files are missing. Did you get error on sql server machine? Can you open packages on that server from other sql client machine? |
|
|
|
danielmeresa
Starting Member
10 Posts |
Posted - 2007-09-02 : 12:33:14
|
| Yes my guess also their is some dll missed related to DTS package. I can open a DTS package from another client machine but stil I couldn't see the Tasks for that package. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-02 : 17:50:42
|
| Try reapply sp on the server. |
|
|
|
danielmeresa
Starting Member
10 Posts |
Posted - 2007-09-03 : 09:52:44
|
| I did SP 4 not working |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-03 : 13:12:04
|
| Another option is reinstall sql client tools and apply sp. |
|
|
|
danielmeresa
Starting Member
10 Posts |
Posted - 2007-09-04 : 09:12:29
|
| I did this options also not working, and my guess is it might depend OS problem |
|
|
|
|
|
|
None of the Task Objects show for DTS