SSIS - varchar max column to varchar

• balasach82

  SSCrazy Eights

  Points: 9653

  More actions

  September 19, 2013 at 11:36 am

  #283431

  Source: large object column, varchar(max) in a table

  Derived column: substring((DT_STR,8000,1252)[Column 0] ,1,10)

  Derived column: substring((DT_STR,8000,1252)[Column 0] ,5,10)

  Derived column: substring((DT_STR,8000,1252)[Column 0] ,7,10)

  ...

  ...

  Destination: SQL table

  Note that 8000 is not the maximum i need, there are values after 8000 too. I need to read and load them too

  How to achieve this? Since I can go with the above steps till i hit 8000. But what after that?

  we cant give like substring((DT_STR,9999,1252)[Column 0] ,5,10)

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  September 19, 2013 at 1:33 pm

  #1651658

  My recommendation would be to do this in the source. If you only need the first ten characters then put a substring into a select statement and use that as your source data rather than putting the large data feild into the data stream. You may see a performace improvement as well.

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.