Conditional Alter Table

• bdloving

  Old Hand

  Points: 302

  More actions

  June 20, 2003 at 7:29 am

  #106689

  Hi, am creating a DTS to import some Access tables. I was wondering if there is a way to check if a column in a table exists and only run an Execute SQL Task (adding identity column) if necessary?

  Tahnks

• June 23, 2003 at 8:00 am

  This was removed by the editor as SPAM

• jfb

  SSCrazy

  Points: 2469

  More actions

  June 23, 2003 at 10:54 am

  #462665

  Hi,

  You can check a record if exist in some table using lookups in DTS.

  Here is an example in how to use it...

  http://www.sqldts.com/default.aspx?6,107,277,7,1

  JFB