October 19, 2013 at 12:18 am
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
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
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy