Hi All,

I am creating a DTS package to export a table to a text
file. After creating and saving the package, I noticed
that I selected the wrong table as the source. So I
change the source table and go to the Destination tab.
Selecting "Define Columns" and "populate from Source"
clears the list showing the column defs.
Selecting "Define Columns" again causes the error below
followed by being thrown out of Enterprise Manager.

- Any help would be greatly appreciated

---------------------------
mmc.exe - Application Error
---------------------------
The instruction at "0x4173d23a" referenced memory
at "0x020b1e90". The memory could not be "written".

In article <036501c3bea0$99a1d2f0$a401280a (AT) phx (DOT) gbl>, Mary
<anonymous (AT) discussions (DOT) microsoft.com> writes
applied the latest service pack to your (client) machine?
If you have applied SP 3 the it could be a bug in SP3 itself, in which
case apply MS03-031 as well, as this includes a rollup fix for this bug
as well as the security fixes.

http://support.microsoft.com/default...B;EN-US;814113

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

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

Instaling the rollup on the client worked!

I had installed the roll up only on the server. The
workstations, which only have the client tools, had Sp3a
installed. I guess it's important to install the rollup
packs on both clients & servers.

Thanks alot for your help.

- Mary

In article <0bbf01c3bf35$c05bcf00$a401280a (AT) phx (DOT) gbl>, Mary
<anonymous (AT) discussions (DOT) microsoft.com> writes
Both DTS core objects and the designer are local, you need to patch
clients to get any updates for these. Same with data access components.

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

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