Home Forums SQL Server 2008 SQL Server 2008 - General Find and update the Schema changes of a table? RE: Find and update the Schema changes of a table?

  • July 30, 2013 at 5:15 am

    #1636918

    Eric M Russell (7/26/2013)

    I wouldn't even attempt to use SSIS to make daily copies of tables with schemas that can change daily.

    First, you can query INFORMATION_SCHEMA.COLUMNS to determine if there have been any changes made to the column definition of a source table. If no changes, then just insert into target table from source table. If there have been schema changes in source table, then drop the target table, and SELECT INTO target table from source table.

    For example:

    drop table [TargetTable];

    select * into [TargetTable] from [SourceTable];

    As simple as that, you can create a new target table with schema and data.

    Okay Eric...How do we update the SSIS packages? You know, once I am done with pulling the data into local....i need to do some conversion, so when i use my SSIS...it's gettting error..So every time i have to open the package through BIDS and update it with latest schemas....Is there any way to avoid opening everytime?