Viewing 4 posts - 1 through 4 (of 4 total)
The patindex function and use of substrings is very useful for creating spiders to parse data from web pages.
March 10, 2016 at 2:39 pm
I figured it out. The import was running fine.
There was some sql code executed later in the package that updated the column to remove " signs.
It was casting to...
September 2, 2008 at 12:47 pm
Under advanced editor for flat file source > input and output parameters :
The flat file source output for my column productdescription is set to Text Stream for External columns and...
September 2, 2008 at 10:45 am
under advanced settings on the Flat File Connection Manager for the column productDescription, the datatype is set to text stream(DT_TEXT)
September 2, 2008 at 9:40 am