SQL Server Performance

How to convert a integer to string in ssis package

Discussion in 'SQL Server 2005 Integration Services' started by r_gautham2001, Jul 20, 2007.

  1. r_gautham2001 New Member

    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
  2. dineshasanka Moderator

    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/
  3. r_gautham2001 New Member

    can we use Typecast function in this issue as it won't need any extra task in package if we can
  4. satya Moderator

    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.

Share This Page