Use an ActiveX transformation, and do something like:
DTSDestination("MyDestinationCol") = chr(DTSSource("MySourceCol")\30 + 65)
Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk
"Enrico" wrote:
Quote:
Hi, I need to know how can i transform a value to a letter:
It goes from a DB to another...
Ex: if 0 to 30 = A, if 31 to 60 =B
anyone can help me please?
Thanks a lot
|
Trasnformation SQL 2k -
09-16-2006
, 08:46 PM
Linear Mode
