Text Import

[Bell1991]

I am attempting to import a text file and update the database based on the text file.

The problem i am having is the text file does not correspond to one column in the table.

For example:

TextFile dbTable
column1 column1
column2 could map to column2 or coulmn3 based on what it is.

Any suggestions?

 

[gradley]

Use an ActiveX script in your transformation to condition which field to import the value to.