Tuesday, March 27, 2012

DTS Export to TEXT File

Okay,

Here the issue...

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.

Thanks for you assistance.http://support.microsoft.com/default.aspx?scid=KB;EN-US;814113

No comments:

Post a Comment