I am trying to create a package that performs a query on a SQL table and
writes out to a fixed length text file. My problem is that I do not want a
column-for-column transformation. Some columns will be written. Some will be
ignored. And others will be broken apart. The only columns listed (under
Define Columns) for the destination (the text file) seem to be the column
names from the query. I am able to change the column names and size but
cannot seem to be able to insert or delete columns.

Any help would be appreciated.

Then do it in your SQL Query.

Yu can soecify a SQL Statement as a source for your datapump.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jason Callas" <JayCallas (AT) hotmail (DOT) com> wrote

If it is not possible to change the number of columns, I should use a select
query to return the columns I want and do a regular column-for-column copy
transformation?

- Jason

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Correct

The text file driver in DTS will only let you create the fields for the ones
it knows of. So say I did

SELECT au_id FROM authors

The text file will have one column

If I want to do all kinds of fancy stuff with au_id then I would do it in
the query

SELECT UPPER(au_id) AS UPPER_auid, LEFT(au_id,3) as
LeftThreeofAuID.....................



--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jason Callas" <JayCallas (AT) hotmail (DOT) com> wrote

Thank you.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote