I have a select script that runs ins a Transform Data Task and saves the results to a flat text file (500 char). I need to be able to save the results without a header(column name). I have to be able to remove the header but see no way of doing it. The Transform Data Task requires a column name to map to when saving to the file. I changed the first row\last row values in the options tab, but id didn't remove the header. in the text file (destination) properties I checked First Row has column names, no luck. Any one have any suggestions?


Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451

You should only get the column names in your export file when you have
checkled "first row has column names", when cleared you get pure data.

The task does not require column names, I don;t understand why or at what
point you think this is required.
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Ron Sissons" <RSISSONS (AT) rcoe (DOT) k12.ca.us> wrote

I have a select script that runs ins a Transform Data Task and saves the
results to a flat text file (500 char). I need to be able to save the
results without a header(column name). I have to be able to remove the
header but see no way of doing it. The Transform Data Task requires a column
name to map to when saving to the file. I changed the first row\last row
values in the options tab, but id didn't remove the header. in the text file
(destination) properties I checked First Row has column names, no luck. Any
one have any suggestions?


Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451

The DTS Transform Data Task has multiple tabs, Source, Destination, and Transformations. The transformations tab asks for a mapping between the source(select statement) and the destination(textfile). This is where it asks for a column mapping.
If I do not qualify my select statement with "AS Record" then I do not have a column name for the transformation tab. That is why I have to have a column name in the select statement. Is there another way?


Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451


You should only get the column names in your export file when you have
checkled "first row has column names", when cleared you get pure data.

The task does not require column names, I don;t understand why or at what
point you think this is required.
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Ron Sissons" <RSISSONS (AT) rcoe (DOT) k12.ca.us> wrote

I have a select script that runs ins a Transform Data Task and saves the
results to a flat text file (500 char). I need to be able to save the
results without a header(column name). I have to be able to remove the
header but see no way of doing it. The Transform Data Task requires a column
name to map to when saving to the file. I changed the first row\last row
values in the options tab, but id didn't remove the header. in the text file
(destination) properties I checked First Row has column names, no luck. Any
one have any suggestions?


Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451

Thanks, That seemed to work. The Task requires column names on the transformation tab, otherwise it errors saying I need a valid transformation and to select a column name or ordinal position.

Process =
SQL Connection -> Transform data task ->Destination text file.



Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451


You should only get the column names in your export file when you have
checkled "first row has column names", when cleared you get pure data.

The task does not require column names, I don;t understand why or at what
point you think this is required.
--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Ron Sissons" <RSISSONS (AT) rcoe (DOT) k12.ca.us> wrote

I have a select script that runs ins a Transform Data Task and saves the
results to a flat text file (500 char). I need to be able to save the
results without a header(column name). I have to be able to remove the
header but see no way of doing it. The Transform Data Task requires a column
name to map to when saving to the file. I changed the first row\last row
values in the options tab, but id didn't remove the header. in the text file
(destination) properties I checked First Row has column names, no luck. Any
one have any suggestions?


Ron Sissons, DBA
Information Technology Services
Riverside County Office of Education
3939 Thirteenth Street, Riverside, CA 92502-0868
Telephone: (909) 826-6471; FAX: [909] 826-6451