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