Error while tranferring data from a text file into database

• ruchi-761283

  SSC-Addicted

  Points: 434

  More actions

  May 28, 2008 at 1:18 am

  #121620

  Hi,

  While i am tring to transfer data from text file to a table into database. its giving error in the Lookup part.

  How to map columns??

  Thanks

• Jan A

  Old Hand

  Points: 345

  More actions

  May 28, 2008 at 2:56 am

  #821032

  Hi.

  Data type is the data source?

  Try to change it to:

  Unicode text stream [DT_NTEXT]

  That was the solution for me.

  \Jan.

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  May 29, 2008 at 1:19 am

  #821611

  I agree, there may be problems with mapping your datatypes.

  Please provide a more detailed example (i.e. keyfield, full datatype on textfile, full datatype on database)

  ~PD