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
    r_gautham2001, Jul 20, 2007
    #2

  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/
    dineshasanka, Jul 20, 2007
    #2

  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
    r_gautham2001, Jul 20, 2007
    #2

  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.
    satya, Jul 20, 2007
    #2

Share This Page