September 19, 2013 at 11:36 am
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)
September 19, 2013 at 1:33 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply