Hi

I am trying to use DTS to add a column to a text file.

I created a DTS package with 1 text file as source and another text file as
destination. I linked both text files with a Transform Data task, but I
could not find how to add a column to the destination on the transformation.
Is it possible to do this without using an intermediary table to load the
source text file and then create the other text file?

Thanks,

Fernando

so you want the destination text file to have 1 more column than the source
?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Fernando Taniguti" <ftaniguti (AT) ccsc (DOT) com> wrote

Yes, I want do add a column, but not to append the column to the end, I need
to insert the column in any position.


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

Personally I have never seen the need to enter columns at specific
places as a SELECT statement negates it but that said

You can.

1. Add to the column names value of the text file connection | Need to
add to the column lengths value as well

This does not seem to wreck your mappings either.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org