Hi,

I am using the trasform data task to transform the table data to the text
file. The table contains around 30 columns.
The problem is that when I selects the destination tab in the transform task
the
'populate from source' windows appears. But when I press the execute button
no columns are displaed in the destination tab. When I again presses the
'Define columns' button. The Enterprise Manager goes down giving the error
message

'mmc.exe- Application Error
The instruction at '0x78010494' referenced memory at '0x00000000'. The
memory cannot be "read"'

Does anybody have any idea about this error.

I am Windows 2000 server, Sql Server 2000 Enterprise Edition with service
pack 3 installed


--
Thanks
Akber.

Known bug in SP3, but you should also have MS03-031, the latest security
roll-up which includes the original hotfix for this problem.

MS03-031: Cumulative Security Patch for SQL Server
(http://support.microsoft.com/?id=815495)


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

"Akber" <Akber (AT) discussions (DOT) microsoft.com> wrote

Will that patch work in SQL Server 2000 SP4? I have the same kind of
problem. Thanks!

In message <1115238727.318489.61810 (AT) g14g2000cwa (DOT) googlegroups.com>, ali
<alireadnews (AT) earthlink (DOT) net> writes
Well you shouldn't. I haven't tested it myself, but the KB now says
"Microsoft has confirmed that this is a problem in the Microsoft
products that are listed in the "Applies to" section. This problem was
first corrected in Microsoft SQL Server 2000 Service Pack 4."

FIX: DTS Designer may generate an access violation after you install SQL
Server 2000 Service Pack 3
(http://support.microsoft.com/?kbid=814113)


If you think that this hasn't been fixed in SP4 (beta I assume), log it.
If you cannot, then give me the build and a repro and I'll try and get
it logged.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Sorry, Darren. Windows is SP4. I was quickly viewing the results of
@@version, saw SP4 and did not notice it was referring to the Windows
version. I suspect SQL is SP3. What is the easiest way to tell that,
since @@version does not show it? Thanks!

Darren Green wrote:

Check the build number-

print @@version

Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
May 31 2003 16:08:15
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

Note 818 above indicates MS03-31. 760 is SP3.



Darren Green
http://www.sqldts.com
http://www.sqlis.com
"ali" <alireadnews (AT) earthlink (DOT) net> wrote