Check this topic out in SQL Server Books Online - Managing ntext, text, and image Data. Not sure about implementing this with the DTS wizard.

To get any error info on the operation

err.clear

    Set  tso = oFSO.OpenTextFile(outFileName, ForWriting, True)

if err.number <> 0 then

   msgbox err.desc

End if   

Try this - when the tso object is closed...

Check out the dynamic properties task in DTS.

BOL

The Dynamic Properties task works by retrieving values from sources outside a Data Transformation Services (DTS) package at package run time and...

Try using an left/right outer join to specify that data from the table on either the left or right side of the join will be returned even if there is no...

changed the location of closing the out text stream, it was closing after every writing a line and not being reopened. Check the error number and description after each operation,...