I have a .txt file that is Pipe delimited with " as text qualifier.
When I import it into Sql Server 2005 using an SSIS data flow task, it imports all of the rows, but one of the columns gets truncated to 30 characters or less.
This column in the original data and file is up to 3500 characters in length.
The destination table has the column declared as varchar(max).
Does anyone have a clue as to why it would chop it off like this.