import TEXT file into varchar(max)

• Regan Galbraith

  SSCertifiable

  Points: 5227

  More actions

  June 19, 2006 at 4:44 am

  #112672

  Hi all,

  It's another work day, which means it's another question from the bemused...

  I have a flat file source - a text file that will contain an undefined about of text. I want to import the entirety of that into a varchar(max) column. Currently I'm trying to do this in SSIS, using SSIS compoent, but I'm have a few issues - a couple of complaints about conversion from str to text (according to the component, it seemed to think that varchar(maz) = text. I cahnged the target column to a varchar(8000), and it worked. That's not going to be a solution, since I'm pretty certain we are looking at > 8000 characters.

  Is there another way, or am I going to have to sink to using an SP, giving it the path to a file, and doing all the work 'outside' SSIS?

  I've tried:

  1> Text Source to SQL Destination

  2> Import Column task

  am I missing the boat again?

• June 22, 2006 at 8:00 am

  This was removed by the editor as SPAM