Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 - SSIS - Difference between signed and Unsigned Integer Expand / Collapse
Author
Message
Posted Saturday, October 19, 2013 12:18 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:47 AM
Points: 405, Visits: 984
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?
Post #1506367
Posted Saturday, October 19, 2013 1:09 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 7:22 AM
Points: 77, Visits: 150
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
Post #1506373
Posted Saturday, October 19, 2013 1:50 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 6:47 AM
Points: 405, Visits: 984
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.
Post #1506374
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse