November 20, 2006 at 9:55 am
We just upgraded to SP4.
When I opened a DTS Transformation Task and pressed OK to save, it closed the entire Enterprise Manger window without saving the task changes.
Any hints?
November 21, 2006 at 12:59 pm
Did you upgrade the SQL client tools on the client side as well? They all have to be upgraded together.
November 21, 2006 at 2:14 pm
Yes, I was working right on the server, and according to the readme, the tools are upgraded along with the database components.
It's something to do with the local parser. I deleted the query, put "Select 1" in as the query, saved it, then put a modified version of the query back and it worked.
However, if I put the line it didn't like back in Enterprise Manager on the server, it kills. On a client machine it debugs to
Unhandled exception at 0x7c910f29 in mmc.exe: 0xC0000005: Access violation reading location 0x00640041.
7C910F29 mov ecx,dword ptr [ecx]
Someone on another board said he was able to solve it by editing from a client machine instead of on the server, but it didn't work for me. I just had to futz with the query till it got past the local parser (I just put "And 1=1" after the part it didn't like, and it was happy!).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply