"Frans van Bree" wrote:

> I would do this as follows:
> - create a staging table, e.g. STG_IMPORT with the maximum number of columns
> in your source file. Eg if B has 6 columns and that's the max, create a table
> with 6 columns
> - 1) create a execute sql task: TRUNCATE TABLE STG_IMPORT
> - 2) create a dts package with a text file source and a db destinator.
> - create a datapump transformation for the 6 columns from source to target
> - 3...)then create a execute sql task for each h, s, f, g, etc like
> INSERT INTO TBL_G (col2) SELECT col2 FROM STG_IMPORT WHERE col1 = 'G'
> and
> INSERT INTO TBL_G (col2, col3) SELECT col2, col3 FROM STG_IMPORT WHERE col1
> = 'S'
> and...
>