<p>I'm running SQL Server 2000 and I need to export the SQL Statement from all the DTS objects so that they can be parsed and put into a wiki documentation if needed.  </p>

<p>Is there a way to do that?</p>

<p>maybe dumping each DTS object out into a text file with the object name as the file name with the name of the process and the date it was extracted as a file header.</p>

<p>thanks.</p>

There is an API with an object model for the DTS packages.  You can get the SQL text through this.  The Books on Line docs describe this to some extent
Here.
You can get examples of the object model usage by
Saving the DTS package to a Visual BASIC file
and looking at what the VB file does to the object model.