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 - 2002-11-06 : 07:40:05
|
| Deb writes "We have SQL 2000 sp2 on NT 5 server. The workstations are NT 4 sp6. I have created a very simple dts package (according to a tutorial) as well as attempting to run a dts package from our payroll vendor. In both cases after pressing the finish button I immediately receive the following message: Executing package Could not create an instance of the DTS packageI searched the internet and found that there may be dlls that need to be registered. I tried registering them and had problems with the following files. dtspkg.dll, dtsui.dll. They received the following message: DllregisterServer in dtspkg.dll failed. Return code was 0x8020009. When trying to register dtswiz.dll I received the following message: dtswiz.dll was loaded but the dllregisterserver entry point was not found. DllregisterServer may not be exported, or a corrupt version of dtswiz.dll may be in memory. Consider using PView to detect and remove it. What is PView and where can I find it?I reinstalled the SQL tools to my local pc, to no avail. I get the same result. I also copied Also my cohort here, has installed SQL also, he does not have problems running the simple test DTS package; which makes me doubt it is SQL Server related. So I need to find out how to resolve this problem. I would greatly appreciate your help." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-06 : 12:59:38
|
| Rather than just reinstalling the SQL tools, completely uninstall it, then install it again. If you still have the problem after that, you might need to rebuild your machine. |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-11-08 : 13:42:11
|
| Also, make sure your SQL service packs are the same between the server and your desk top. |
|
|
|
shifis
Posting Yak Master
157 Posts |
Posted - 2005-05-17 : 18:23:21
|
| I am having the same situation could you solve the problem? |
|
|
|
|
|
|
Could not create an instance of DTS Package