Hello,

Im trying to execute an XML Source task to SQL Server Destination. SSIS
Creates a column [[ElementName]_Id] and makes it a type of DT_Uint8 - an 8
byte signed int. SQL Server doesn't seem to know how to convert this to big
int, or even the default DT_Numeric that it sets up for the table. This
definately seems to be some kind of bug, or at the least a huge annoyance.
Any suggestions for mapping this type?

thanks,

--
Rob Schieber

Rob Schieber wrote:
You have to use a Data Conversion task to convert the data types.
AFAIR there's no automatic data conversion by intention to avoid
"strange errors" which occur only sometimes (e.g. the target field
is too small to take the value)

HTH,
Gerald