View Single Post
  #4 (permalink)  
Old April 14th, 2004, 12:15 PM
jbenson001 jbenson001 is offline
Friend of Wrox
Points: 4,332, Level: 27
Points: 4,332, Level: 27 Points: 4,332, Level: 27 Points: 4,332, Level: 27
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2003
Location: , NJ, USA.
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

You can easily set up a DTS and not have to worry about formatting. When you set up the Transform Data Task, on the Options tab, you can specify what row to start pulling the information from. Accoring to your sample layout, it looks like it will be row 4. Let me know if this helps or you need more info.