MySQL Issue with TinyInt Column Using SSIS IN SQL Server 2012

• amcalpine

  SSC-Addicted

  Points: 439

  More actions

  July 1, 2014 at 9:38 am

  #290528

  Hi There

  Can anybody help. We have an SSIS package that is pulling from MySQL database and we are getting the following error :

  Description: The data type of "DataSource1.Outputs[ADO NET Source Output].Columns[Col1]" does not match the data type "System.Int16" of the source column "Col1".

  From the SSIS metadata it looks like the DTS package is trying to define this as DT_I1 but this does not map to the System.Int16

  From the SSIS Documentation I can see the following :

  DT_I1 maps to System.SByte (it has no SQL Server equivalent data type)

  DT_I2 maps to System.Int16 (SQL Server equivalent SMALLINT data type)

  This is a real pain for me at the moment and was wondering if anyone else has seen this error before ?

  Any suggestions greatly appreciated

  Thanks

  Alan

• amcalpine

  SSC-Addicted

  Points: 439

  More actions

  July 2, 2014 at 3:03 am

  #1726415

  http://idiot-howto.blogspot.co.uk/2008/07/mysql-cast-limitation.html

  A simple MySQL query.

  select (d.tiny_int*1) as tiny,

  (d.small_int*1) as small,

  (d.medium_int*1) as `medium`,

  (d._int*1) as regular,

  (d.big_int*1) as big

  from datatype_test d;

  When you multiply the columns with any number, the result data type is not same as the original data type.

  Apparently this will make all the columns look like BigInt?

  Not sure if this will work but might be worth a try.