SQL 2008 - SSIS - Difference between signed and Unsigned Integer

  • In SSIS 2008, what is the difference between signed and unsigned integer. In table, the datatype is Integer, if thats the case, then what is the ideal datatype in ssis?

  • Hi Balasach82,

    An unsigned integer does not hold negative values. The value range is from 0 to the maximum of the datatype.

    http://bi-architects.blogspot.fr/2011/12/ssis-datatypes-vs-sql-server-datatypes.html

    Hope it helps.

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012

  • Yeah, i knew signed/unsigned integer differences. What i wanted was the exact datatype match between ssis and sql table, which i got from the link you have given. Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply