• 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.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho