How to convert a integer to string in ssis package | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to convert a integer to string in ssis package

Hi All, I tried to assing a integer variable value to a string variable using expressions but I got a error saying typecast mismatch. which typecast function can I use for this operation and do we have any sort of documentatin for these functions in SSIS. Thanks,
Gautham.R
There is a data flow task called data cinversion. use that —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
can we use Typecast function in this issue as it won’t need any extra task in package if we can
You often need to do a Cint or Cstr to convert to correct datatype. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>