Post reply

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

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply