"Per Salmi" <per@litho.se> wrote in message
news:%23OD4rWReDHA.3228@tk2msftngp13.phx.gbl...
> I have a package that imports a text file to a table.
>
> Now I have to add a few columns to both the text file and destination
table.
> The source file view seems to refresh automatically when selecting the new
> file in the source tab of the transfor data task properties but I can't
make
> the new destination table columns appear!
>
> On the transformations tab there are only the old columns and it I can't
> refresh it in any way...
>
> How can I get the package to refresh and add the new columns so I can add
> mappings to them?
>
> /Per Salmi
>
>

> I have just done this
>
> Created a text file of
>
> A,B,C
> 1,2,3
>
> I then created a table
>
> NTD (A,B,C)
>
> I then created a DataPump task between the two mapping the columns.
> I came back to QA and issued
>
> ALTER TABLE NTD ADD D varchar(50) NULL
>
> I added the same column to the text file
>
> I went back to my pump
> Previewed the Source - Col was there (Text File)
> Destination tab showed the column D in the destination
> Transformations tab showed the columns D in both Source and Dest with no
> transformation between them.
>
> Are you sure you are inserting into the table and not a view ?
>
>
>
> --
> --
>
> 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
>
> "Per Salmi" <per@litho.se> wrote in message
> news:%23OD4rWReDHA.3228@tk2msftngp13.phx.gbl...
> > I have a package that imports a text file to a table.
> >
> > Now I have to add a few columns to both the text file and destination
> table.
> > The source file view seems to refresh automatically when selecting the
new
> > file in the source tab of the transfor data task properties but I can't
> make
> > the new destination table columns appear!
> >
> > On the transformations tab there are only the old columns and it I can't
> > refresh it in any way...
> >
> > How can I get the package to refresh and add the new columns so I can
add
> > mappings to them?
> >
> > /Per Salmi
> >
> >
>
>