Want to take a string I have coming in for example '2000.39-' and change it into a decimal so that it shows -2000.39, was hoping to use a derived column transfer, just having an issue with figuring out how to put it together.

Is it coming from SQL - if it is you could do this in the select- SELECT Cast('-' + Left(Replace (columnName,'''',''),Len(columnName)-1) as decimal(6,2)); http://lqqsql.wordpress.com

Use this expression: (DT_R4)(RIGHT(Num,1) + SUBSTRING(Num,1,LEN(Num) - 1))Nitesh Rai- Please mark the post as answered if it answers your question

Is it coming from SQL - if it is you could do this in the select- SELECT Cast('-' + Left(Replace (columnName,'''',''),Len(columnName)-1) as decimal(6,2)); http://lqqsql.wordpress.com Its coming from a flat file