Data Conversion task and data types

• CountCet

  Ten Centuries

  Points: 1371

  More actions

  May 14, 2007 at 1:12 pm

  #178514

  I posted this the other day in a different forum but I think it was the wrong forum. Anyways,

   

  I'm creating my first SSIS package and I have yet to fully understand the data conversion.

  I have a table with a single varchar(75) column.

  And example would look like this

  4032555445552215555333

  I need to grab some substrings and convert them to integers and a couple to just string type data.

  With t-sql I would usually just CAST(SUBSTRING(Data,16,1) As Int) AS ColumnName

  for each integer type column. For the string data I just use SUBSTRING(Data,10,2) AS ColumnName.

  With a Derived Column task I am trying to do the same thing. I have tried several different expressions but I am not having any luck. The destination table has data types nchar and int.

  What expressions would I use?

  Thanks!

• Gigi Sullivan

  SSC Enthusiast

  Points: 110

  More actions

  May 15, 2007 at 2:47 am

  #706428

  Try this (regarding the integer type column)

  (DT_I8)SUBSTRING(Data,16,1)