sql server dts: In DTS designer, I get an abend when trying to define the
destination fuile format for an export file in cvs
format. The column list appears empty after defining the
query. When I click on the Define columns Button, I get
a mmc.exe application error.

The message is

{"The instruction at "0x4173d23a" referenced memory
at "0x01851e90". The mrmory could not be written.
Click on OK to terminate the program.}

The error terminates the DTS Designer mmc session, and
sends an error report to Microsoft.

I am running SQL 2000 SP3 on Windows 2000 SP4. The erro
is the same whether I run on the SQL Server or on my
Windows/XP workstation. Any ideas?

Chris Combs

This looks like a known issue introduced by SP3. If so, you need to get a
fix from Microsoft. For more information:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814113

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




[quoted text, click to view]
In DTS designer, I get an abend when trying to define the
destination fuile format for an export file in cvs
format. The column list appears empty after defining the
query. When I click on the Define columns Button, I get
a mmc.exe application error.

The message is

{"The instruction at "0x4173d23a" referenced memory
at "0x01851e90". The mrmory could not be written.
Click on OK to terminate the program.}

The error terminates the DTS Designer mmc session, and
sends an error report to Microsoft.

I am running SQL 2000 SP3 on Windows 2000 SP4. The erro
is the same whether I run on the SQL Server or on my
Windows/XP workstation. Any ideas?

Chris Combs
PetPartners Inc

Your problem is this

http://support.microsoft.com/default.aspx?scid=kb;en-us;814113


--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community