Groups | Blog | Home
all groups > sql server dts > june 2004 >

sql server dts : DTS Error


nicky
6/5/2004 8:54:57 AM
Hi,

I am getting the following error when I try to export a
table to an text file:
The instruction at 0x77bd4d30 referenced memory at
0x00000000. The memory could not be read

and then a second one

The instruction at 0x4173d23a referenced memory at
0x01d71e90. The memory could not be written

The errors occur when I am clicking on excecute to define
the columns in the destination file.

Any ideas why?
Thank you

nicky
6/5/2004 11:44:09 AM
Thank you!

How can I see which service pack is installed?
[quoted text, click to view]
Allan Mitchell
6/5/2004 5:13:38 PM
This is most likely due to the install of SP3 for SQL Server.

The details are here along with the fix

814113 - FIX DTS Designer May Generate an Access Violation After You
Install SQL Server 2000 SP3
http://support.microsoft.com/default.aspx?scid=KB;EN-US;814113

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Allan Mitchell
6/6/2004 10:08:52 AM
select @@version

http://vyaskn.tripod.com/sqlsps.htm

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

AddThis Social Bookmark Button