I orginally asked this question here: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21708078.html
Since then I'm having problems with this DTS. It now fails on the line I use to convert my weird "0*100*0" rows to true money fields.
This is the error I get now: Cannot convert a char value to money. The char value has incorrect syntax.
This worked back when I first tried it and now I'm coming back to this DTS package and its failing on these conversions. Any ideas? I scanned the entire table looking for something out of the ordinary and I found nothing. The fields in my temp table are in varchar format. Final table is set to money.