Converting Varchar to smallint

• kishoremania

  Ten Centuries

  Points: 1059

  More actions

  August 11, 2011 at 9:13 pm

  #242126

  I am trying to convert Varchar(5) to smallint,

  I tried in both Derived Column transformation and Data conversion transformations using Typecast function with (DT_14).(showing in Red color)

  I am getting 3 types of errors:

  1. Cannot parse the expression "(DT_14)" . The expression was not valid or out of memory.

  2. The expression "(DT_14)" on input Column is not valid.

  3. Failed to set expression on input column.

  Can anyone resolve it?

• kramaswamy

  SSCoach

  Points: 18181

  More actions

  August 12, 2011 at 7:58 am

  #1367937

  What is (DT_14) ? Are you trying to convert to an integer? If so, you should be using (DT_i4). Note that is a letter, not a number. I've put it in lower case to make it more clear, although it should be capitalized.

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  August 14, 2011 at 9:52 pm

  #1368451

  (DT_i4) returns a 4 bytes integer. If you need a smallint, you should use (DT_i2) instead

• gmuchan

  SSChasing Mays

  Points: 645

  More actions

  August 15, 2011 at 3:37 am

  #1368489

  I always find this link (especially the chart at the bottom) useful for matching up sql server data types to SSIS data types

  http://msdn.microsoft.com/en-us/library/ms141036.aspx

  G