|
|
You're in the
sql server dts
group:Can't exit from interactive DTS package under SP4
sql server dts:
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? --
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 [quoted text, click to view] "Jim Langley" <JimLangley@discussions.microsoft.com> wrote in message
news:JimLangley@discussions.microsoft.com: > 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
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 [quoted text, click to view] "Jim Langley" <JimLangley@discussions.microsoft.com> wrote in message
news:JimLangley@discussions.microsoft.com: > 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: > > > 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@discussions.microsoft.com> wrote in message > > news:JimLangley@discussions.microsoft.com: > > > > > 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 > > > >
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 [quoted text, click to view] "Allan Mitchell" wrote:
> 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@discussions.microsoft.com> wrote in message > news:JimLangley@discussions.microsoft.com: > > > 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 >
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 [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > news:JimLangley@discussions.microsoft.com: > > > 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: > > > > > 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@discussions.microsoft.com> wrote in message > > > news:JimLangley@discussions.microsoft.com: > > > > > > > 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 > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |