"gilbertcj@gmail.com" <gilbertcj@gmail.com> wrote in message
news:1133265555.736104.135440@g47g2000cwa.googlegroups.com:

> 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.