SQL 7 Exporting Data with export tool to CSV file

[lsgko]

I'm trying export data from a database (using an SQL query which runs correctly). When I try to do this I get the following error message:
1) DTS Wizard Error
Error Srouce: Microsoft Data Transformation Service (DTS) Package
Error Description: Please specify a valid Name and Ordinal Value for the Column

2) Copy Data from Results to c:\file.csv Step
The Data Pump Task requires Transformations to be specified.

I'm using the following settings:
Source Table: Query
Delimited
File type: ANSI
Row Delimiter {CR}{LF}
Column Delimiter: Comma
Text Qualifier: Double Quote(")

 

[mrdenny]

Make sure that all of your columns have a name. If any columns are using a count, min, max, case, etc you need to alias them to a column name for DTS to be able to use the column.

Denny

--Anything is possible. All it takes is a little research. (Me)