Editing DTS Task Closes DTS/Enterprise Manager

[pbackstrom]

We just upgraded to SP4.

When I opened a DTS Transformation Task and pressed OK to save, it closes the entire Enterprise Manger window without saving the task changes.

Any hints?

 

[TomKane]

Hi,

Is this the case for all your DTS packages?

I have seen that before with one particular DTS - it would close down Enterprise Manager if we attempt to edit it on the server itself - the way we got around it was to switch the editing to a different machine.

Hope this helps.

Regards,
Tom

 

[TomKane]

When I say different machine, I mean that we edited the DTS on the server from a client machine accessing the server.

 

[pbackstrom]

Thanks. Yes I was term-served directly to the server, will keep this in mind for the future.

I wound up cutting the query, replacing it with "Select 1", saving it (which it accepted), editing the original query in notepad, then pasting it back in. That wound up working too.

 

[TomKane]

Well done.