am trying to tell DTS the column names (comma delim .csv file, 1st row
column headers) of my import file to use, and I would like to do that
dynamically. I have thought of using a table to map the import file column
to the destination table column or (which seems to work better), use a INI
file to specify a global variable and source file column name pair, then
somehow tell DTS to use this (via vbscript) dynamically.

I would like my transformation script to use the global variables as column
names and map to the destination columns.

I cant sem to put this together in my mind how this would play out and how
to connect all the dots.

Anybody have any ideas? done this before?

thanks in advance!

Randy