Very Computer

Hiya!

I am trying to export a table from a SQL 2000 Server (SP3) (with 3
integer and 250 float columns) to a flat CSV file.

I am using the graphical DTS package designer in the Enterprise
Manager. I insert the SQLDB connection, the flat file, and the Data
Transformation (DataPump).

I choose the source Table, want to set the destination options, get a
list with the column names, klick on EXECUTE to add them, and NADA.

Wenn I click on "define columns" the Enterprise manager crashes.

This means that I can't define transformations!!!

The same thing on a table with varchar, etc. columns works perfectly.
I got it even running on a SQL 2000 server with SP2.

Hope you know what my prob is... HELP

See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;814113

--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/

Quote:> Hiya!

> I am trying to export a table from a SQL 2000 Server (SP3) (with 3
> integer and 250 float columns) to a flat CSV file.

> I am using the graphical DTS package designer in the Enterprise
> Manager. I insert the SQLDB connection, the flat file, and the Data
> Transformation (DataPump).

> I choose the source Table, want to set the destination options, get a
> list with the column names, klick on EXECUTE to add them, and NADA.

> Wenn I click on "define columns" the Enterprise manager crashes.

> This means that I can't define transformations!!!

> The same thing on a table with varchar, etc. columns works perfectly.
> I got it even running on a SQL 2000 server with SP2.

> Hope you know what my prob is... HELP