I am exporting a table to a text file using DTS. Such an easy task.
This process I had in place worked, then I added a new column to the table. So I had to remap the destination and source column. When I try to do this Enterprise Manager just gives me some type of mme.exe error that relates to memory and closes.
This column made column number 22. Everytime I do this to any table with 21 columns or less it works fine, tried to do this against some tables with 22 or more and ran into the same problem.
I searched Microsoft and did not find this as a limitation. So does anyone have some insight.