SQL Server 2000 Service Pack 4
When running a DTS package interactively in Enterprise Manager, there is no
way to close the package when it completes. There is no OK or Close button on
the form. Also Cancel does not work. The package remains open and you have to
use task manager to kill Enterprise Manager. Any ideas? hotfixes? workarounds?
--
Jim Langley

I am running SP4 on one of my boxes here and I have just run a package
that exports to a text file.

After the package runs I get the OK button to say it ran OK and then I
get the "Done" button to close the running of the package.

I can then exit from the package.

If this is not happening for you then maybe something got confused on
the install of SP4.


Allan


"Jim Langley" <JimLangley (AT) discussions (DOT) microsoft.com> wrote

You are right. My previous statement was not specific enough. Further
analysis and test shows the in general DTS packages work correctly, howeve, I
have been able to consistently cause the previously described problem under
one condition.

Create a new package in Data Transformation Services
Connection 1: local SQL Server database
Connection 2: Oracle Rdb ODBC driver (Latest release)
Transform Data Task: Simple transfer of data from SQL Server to Oracle Rdb
in identical tables
Save the package
With the package designer open or closed, execute the package.
The package executes to completion.
Normally the Cancel button will gray out and a message box will pop up with
an OK button. Click the Ok button and a done button will show. etc.
Under the above conditions, the package can not be canceled, when complete,
there is no Ok message box when complete. Every thing is basically
unresponsive.

Using the Task Manager, select the Enterprise Manager and click end task.
The message that then pops up is that the task is waiting for a response from
the user.

--
Jim Langley


"Allan Mitchell" wrote:

OK so how do you know it completes? Do you get the Green circle to say
completed and not the green play button to say executing in the UI?
Has the dialog box from which it would seem to want a response been
hidden? Sent to the back?
Do you set the connections to close on completion in the Workflow
Properties of the step?

I do not have an O instance to play with on my laptop and I am in a
hotel currently so am flying a little blind



"Jim Langley" <JimLangley (AT) discussions (DOT) microsoft.com> wrote

In the package execution dialog, the green play mark on the step line changes
to a green checkmark. The Staus changes to Complete (6116) for the number of
rows transferred. I thought that the OK dialog might have been hidden, but
I've minimized or shrunk all windows so that if appeared behind a window I
would be able to see it. Note: Usually when a DTS package completes, I can
hear the sound event being played. In this case there is no sound event.
Can't set the Work Flow properties in the test package. There are two
connections and the Transform Data task. Trying to select anything under
WorkFlow onlu produces an error. The package properties are set to commit the
work upon completion.
I've checked the Oracle Rdb ODBC driver settings in the DSN and the are no
obvious settings. I'll also check with Oracle to see if they have any
information.
Thanks


--
Jim Langley


"Allan Mitchell" wrote: