Hi!

I have a problem regarding a DTS package. The package is residing on a
machine that will be formated in near future. On that machine I have a simple
DTS package that was created when choosing an "import data" from an access
2000 database too a sql server 2000 sp3. It simply deletes from sql server
tables and imports new data from an Access database.

Well, I saved the DTS packages from the old machine to the new machine. Both
sql server 2000 sp3. I just used "save as". Now, the packages are saved to my
new machine. Then, I had to alter the sql server connections in the package
from the old machine too the new one. When doing so, I got a question
regarding deleting transactions. By "mistake" I deleted all, saved the
package and tried to execute it. Then all the tasks failed with the error:
The Data Pump Task requires Transformations to be specified.

OK, so I delete the package and saved it again. This time when I altered the
sql server connection, I did not select to clear transactions. I saved the
package and tried to execute. Now the package execution just hangs for ever
after doing the first "delete from..." statement.

Any ideas? I could just make a new package by doing an "import data" you
would probably think, but I am not able to do so! There seems to be a problem
with connecting to the Access database when trying to make a new package. The
access database works, but we are not able to make new packages. Old packages
work though. We have tried to resolve that issue too, but with no luck.

If I try to import a table in sql server enterprise manager, choosing my
access database as source and my sql server as destination, when I hit Next,
EM just goes down. In the error log i can see this:
Faulting application mmc.exe, version 5.2.3790.0, faulting module
msjet40.dll, version 4.0.8618.0, fault address 0x000d10cb.

Well, the last issue is just more of a "if you should happen to know...".
The first issue is important.

I will try to post the last issue as a separate case

Thanks!!

Henning

OK the second part of your Question you asked in another
thread and I have answered there but the first part.

If after you broke the transformations and saved it back
you simply did "Save" then in EM in the DTS folder you can
right click on the package and choose "versions". It will
give you a list of incarnations for that package. Choose
the unbroken one and redo what you were doing.

Hi again!!

Thanks for all the replies.
Well, It doesn't matter if I undo the "clear transformation". Then the
package just hangs during execution. (sorry, I wrote "clear transaction" in
my post, but you understood!)

I hope I understood what you meant. The versioning doesn't apply, because I
did the whole process one more time and did the opposite from the first
attempt.

Henning :-)

"Allan Mitchell" wrote: