How does dropping and recreating a table in ssis effect partitions?

  • I inherited a pkg that drops a staging table, recreates the staging table, then loads the staging table. Then it renames the main table to include "_Backup" concatenated to the end of the name. Then renames the staging table as the main table. The main table is partitioned. How would these processes effect the partition on the main table?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply