Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
automatically add new column to existing table.

Proposed Answer automatically add new column to existing table.

  • Monday, October 24, 2011 9:38 AM
     
     
    Sign In to Vote
    0

    I have an etl process that imports a "flat file".  say, it has 2 columns and it is importing fine.

    Is there a way to automatically change the import so that it will know a third column is introduced and import that new column?

    i guess that also mean, it needs a way to create the new column into the table.

    Thanks.

     

    -- IBM has jobs for USA employee to work oversea (India) and get their wages.
     

All Replies

  • Tuesday, October 25, 2011 9:13 AM
     
     Proposed Answer
    Sign In to Vote
    0

    Hi Light_lt,

     

    I think you may have posted this question in the wrong forum. But in answer to your question you'd have to open the package so the metadata refreshes for any additional columns to be added to the other data flow tasks. This is probably the most simplest way. 

     

    HTH

     

    C

    • Proposed As Answer by Zilong Lu Wednesday, October 26, 2011 3:24 AM
    •