When to DTS Object Model??

• deepaks

  Newbie

  Points: 5

  More actions

  July 17, 2003 at 1:11 am

  #105786

  Hi,

  I have many bussiness rules while transformation fron Access to SQL SERVER 2000.

  So, Wheteher i should go for DTS Designer or DTS Object Model in VB.

  Thanks in Advance..

  Bye

  Deepak

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  July 21, 2003 at 11:23 am

  #466254

  I use the designer up front and stick with that if I can. It takes a lot of code to do what the designer does. Even if you need to embed in VB, use the designer as a code generator.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn