Post reply

SQL 2008 - SSIS - Difference between signed and Unsigned Integer

  • October 19, 2013 at 12:18 am

    #281588

    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?

  • October 19, 2013 at 1:09 am

    #1659893

    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

  • October 19, 2013 at 1:50 am

    #1659894

    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