"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uzFCVuUeDHA.2312@TK2MSFTNGP09.phx.gbl...
> 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@ccsc.com> wrote in message
> news:OVjnZpUeDHA.956@TK2MSFTNGP09.phx.gbl...
> > 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
> >
> >
>
>

"Fernando Taniguti" <ftaniguti@ccsc.com> wrote in message
news:OVjnZpUeDHA.956@TK2MSFTNGP09.phx.gbl...
> 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
>
>