Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to compare database table schema in SSIS package Expand / Collapse
Posted Wednesday, December 10, 2008 10:27 PM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, April 10, 2014 3:42 AM
Points: 890, Visits: 1,179
We are using SQL Server 2008.
We will use SSIS package to upgrade the database schema.
Current approach to upgrade the schema (with DTS package)
Ø Creating temp table
Ø Transfer the existing data with transformation task
Ø Drop the existing table
Ø Rename the temp table
Hence, new table with newly schema is available in database.

SSIS Package approach
Temp table and transferring the existing data is not required, if tables schema is same as available in SSIS package. This step can be bypassed.

Is there any way we can compare table schema in SSIS? If table definition which is present in SSIS (or any SSIS task) & current db connection will is going to upgrade is same then I want to bypass the data transfer task.

Request you to suggest the way to compare database table schema in SSIS package.
Please also suggest any alternative to achieve the same.

Post #617596
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse