MS SQL Server DTS - Dynamically Telling DTS about input file

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Dynamically Telling DTS about input file

Randy hartwig

2005-07-19, 1:23 pm

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

Sponsored Links