I am experiencing problem discussed in this article:

http://support.microsoft.com/?kbid=818540

(DTS Designer blows up and crashes EM when modifying dts task that uses SQL
Calculated Columns as source)

I need a work around as this is on a system where I cannot install SP4


any thoughts ?



Greg Jackson
PDX, Oregon

nope. It was only fixed in sp4.

I'm working around this by doing this task as a VBS

sux but it will work


GAJ

AFAIK it was remedied here

http://support.microsoft.com/kb/821277/

And I know of not other way of fixing it.

Allan



"pdxJaxon" <GregoryAJackson (AT) Hotmail (DOT) com> wrote

I was going by the section at the bottom of the article you posted

REFERENCES
This hotfix is also available in the MS03-031 security patch. For
additional information about the MS03-031 security patch, click the
following article number to view the article in the Microsoft Knowledge
Base:
821277 MS03-031: Security patch for SQL Server 2000 Service Pack 3




"pdxJaxon" <GregoryAJackson (AT) Hotmail (DOT) com> wrote

The first service pack which rolled up the fix was SP4. The MS03-31 security
patch (hotfix) was the first publicly available rollup that included the
original bug fix. There was a specific hotfix for the bug prior to this, but
that was never public. Any other public hotifx after MS03-31 would also
include it as they are cumulative these days.

If you are running SP3 then you should definitely be running MS03-31 for
security.

Saying all that in your case the bug is with EM which means the SP/fix needs
to be applied to your workstatiopn upon which you are running EM, which is
probably not the same machine as the SQL server, so any issues you have
about service packing the server are non-issues if you ant to just solve the
crash of your local EM today. DTS in particular client-side, and most people
forget to patch clients, even though they of course have tools or data
access components on which are covered by SQL patches.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"pdxJaxon" <GregoryAJackson (AT) Hotmail (DOT) com> wrote