I had a working DTS datapump task.

I added columns to the source table.

When I open the datapump task to map the new source columns, the changes are
not reflected in the available source columns. The changes to the table have
been saved. What I have available is the old table structure.

Any suggestions?

TIA

In message <153EBE95-7D5E-4E5D-8951-261AAA6CC557 (AT) microsoft (DOT) com>, Mike T.
<Mike@T.?.invalid> writes
Check you are connecting to the same server, database and table. When
you open the task UI it always refreshes the columns, which is normally
the cause of problems, not the lack of it!

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

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