DTS with no nulls property on destination table

• John Peterson-281170

  Newbie

  Points: 1

  More actions

  November 28, 2005 at 1:39 pm

  #169802

  Help would be greatly appreciated on this.

  Using DTS to migate data from one SQL server to another. Destination tables have fields that require data (not null property) and are fields that are irrelavent to our migration)

  We created a secondary task to insert default values in these fields The original migration task fails because it recognizes the not null property before the insert task can run.

  We need SQL (or activeX) lanquage inserted so the insert task will be allowed to run (and the record insertion completed).

  Here are the select and insert tasks.

  PRTCAT

  SELECT     si_prod_id, si_prod_desc, si_prod_units, unique_id

  FROM         si_prod_mstr

   

  PRTSTK

  SELECT     sii_avg_cost, si_whse_id, unique_id

  FROM       

   sii_invtry_dtl

   

  PRTAREA

  SELECT     si_whse_id, si_whse_desc

  FROM         si_whse_mstr

   

   

   

  INSERT

  INTO IMSV7.PRTCAT

                        (DELETED, PRTAKIT,

  PRTCRITICL, PRTLOTTRCK, PRTONCNTCT, PRTSERIAL, PRTSTKED)

  VALUES

      (1, 'N', 'N', 'N', 'N', 'N', 'N')

   

   

• Andrés D'Elia

  SSChasing Mays

  Points: 656

  More actions

  November 29, 2005 at 7:13 am

  #606402

  I'm not sure about your problem, but may be this can help.

  Did you try to use a DataPump (bulkInsert) task with an SQL as a Source?. In that SQL sentence you can "map" default values to the Not Nulls columns.

  Regards,

   

  Andrés

   

   

   

  ---

  Regards,

  Andrés D'Elia