I am unable to create a header row in the presource step of a multiphase data pump from a SQLServer to a destination text file.

Using the DTS Designer, one the transformations tab, I selected the first field of the destination, I selected presource if the "phases filter" drop down box, and created a new activeX "transformation".

In the activeX script I set the destination column to the text string I wanted to use for my transformation.

When I execute the data pump the text file does not have the header row. And if I test the activeX script (from the little script builder window) the presource step completes successfully, the view results doesn't show and data in the column.

Has anyone ever successfully used the presource step to create a header row in his or her export file?

Thanks,
Wes