I have a problem using DTS (SQL Server 2000) to export to a text file.
If I try to create the DTS using the designer if I am exporting from a
table with more than 16 columns when I come to define the columns in
the text file Enterprise Manager consistantly crashes.

The steps to reproduce are as follows:

1. Create a new DTS package
2. Add a server source
3. Add a text file destination in a temp dir
4. Create a transformation between the two
5. Select a table with more than 16 rows as the source
6. Click on the destination tab
7. In the modal window click execute
8. Click define columns
9. Hey presto, kaboom (at least on my machine)

Is this reproduceable and does anyone know how to get around it? I
can't believe I am the first person to find this but I can't find a
solution.

You are not the first person to experience this. It was a problem
introduced in SP3. Fixed in hotfixes after that and SP4

http://support.microsoft.com/default...b;en-us;814113

Allan

"gilbertcj (AT) gmail (DOT) com" <gilbertcj (AT) gmail (DOT) com> wrote

Thanks Allan,

You are correct, although my local SQL Server installation is patched
our development server is not.

If anyone else is in this position then you can fix the problem by
reducing the columns to 17 or less (from memory - I'll come back and
edit this if I find that this is not the correct number). Obviously
not ideal but it will work.