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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-07-24 : 18:57:25
|
| Hi,I have a DTS package doing an import into production table. It runs fine from client's desktop with 'sa' priviliges.Weirdly, when I log into server box and double click on the dts package or any package for that matter, it gives me an error msg"Error: DDL not found".Have any idea why? The DEV and TST servers open the package fine, the error is only on production server.Should I be comparing all dlls now to see which one is missing?Thanks,Sarat. |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-07-25 : 11:28:41
|
| Where is the import coming from? DTS uses files and settings on the machine where the package is run. I'd start by verifing that SQL Service Pack levels and MDAC levels match on all machines.Jeff BanschbachConsultant, MCDBA |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-07-25 : 13:08:13
|
| The reason we have this DTS package is to to be able to connect to our AS400 box. So we installed a Client-Access ODBC but we did the same on other 2 servers.So, I have a program which calls the DTS package which connects to AS400 and then reads data from an interface file on AS400 and writes to production table on SQL Server. I feel the program is ok because it works on other servers. I have another DTS package to copy tables from Prod Box to Dev box which used to work fine before.All of a sudden I cannot open any DTS package on the server box. When I go to EM - DTS - Local Packages - Double Click on any package, I get the error.Can it be possible that we deleted/overwrote some files? Then how it works for other boxes, they all have service pack 2 and have same MDAC version.Can we uninstall and reinstall DTS only?thanks!sarat. |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-07-25 : 15:27:43
|
| Something had to have changed if it worked before and now it doesn't. Sounds like the packages were edited or created on a machine with a higher service pack that what the server has... That's about my only guess. Sorry I couldn't be more help.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
DTS error message on server box