Post reply

SSIS Import of Compressed Tables?

  • November 29, 2010 at 8:24 am

    #144170

    Moving tables to a datawarehouse from a source where the tables and indexes are using page compression.

    Is it possible in SSIS to move the tables and keep them page compressed?

    How about the indexes?

    Thanks much.

  • November 29, 2010 at 2:00 pm

    #1256488

    Sorry guys. Answered my own question. Using "Transfer SQL Server Objects" in SSIS will bring over schema, indexes if specified. If the table of origin is compressed, the resulting table will be compressed.

    Have a good day.

Viewing 2 posts - 1 through 1 (of 1 total)

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