Convert Text file Into XML File

[teblack]

We are attempting to convert a Text file from a Mainframe system into an XML file with DTS. We are having problems getting anything to work, has anyone been successful with this process?

Thanks in advance for the help with this problem.



TBlack -

 

[TomKane]

I've done it recently with vb6 - DTS has activex script support (assuming you're using SQL 2000 or older)

Hope it helps

http://www.devx.com/getHelpOn/10MinuteSolution/20356