I am trying to export ntext using the package created by SQl Wizard to a flat file and get conversion error

• aussierock

  SSC Veteran

  Points: 201

  More actions

  July 8, 2008 at 9:17 pm

  #189372

  I get the following error when trying to execute a package in SSIS created by the export wizard in SQl 2005.

  [Destination - txt [19]] Error: The data type for "input column "text" (26)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.

  It worked fine when manually run but I must have the field type in the table as Ntext as I am inserting a lot of data in a certain format. Have you come across this and what was the solution to get the pckage to run succesfully.

  Thanks

• sharon.bender

  SSCrazy

  Points: 2853

  More actions

  July 9, 2008 at 12:30 am

  #839882

  Hey AussieRock.

  I had the same thing happen to me.

  I was trying to find the example for you of where it happened, but I haven't been able to dig it up.

  Basically, when you export, the system is having a problem with wanting to be a fixed size. If you can change your source from ntext to text you won't have this problem, or alternatively, write code to convert the field to a fixed width prior to doing your output.

  This fixed it for me anyway... sorry that's a bit vague but if I find the example I'll post it for you.