DTS Packages

• Richard Sabbara

  Ten Centuries

  Points: 1382

  More actions

  September 7, 2006 at 12:36 pm

  #172473

  I am in the automation process of my project and I need to create several DTS packages, the simple ones that go out and do a straight import on the file I have figured out.  What I want to be able to do next is learn about how to maniuplate data as I am loading it, which is the next logical step, where can I read up on this that will show me actual examples?  I would prefer web based resources if possible, books are fine but with the things on the web, they tend to be more boiled down.

  Thanks,

  Richard

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  September 7, 2006 at 2:24 pm

  #659201

  SQL Books Online is the good place to go.

  Thanks

  Sreejith

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 7, 2006 at 2:50 pm

  #659214

  See http://www.sqldts.com/ .  If you change your mind about a book, my favorite is 'Professional SQL Server 2000 DTS' by Chaffin, Knight & Robinson.

  Greg

  Greg