Can I reuse a DTS package -
09-01-2003
, 06:02 PM
I populate a CSV with records form a DBF giving it a
header based on the field names. I have then created a
DTS package which populates a temporary table with this
data. The data from the temporary table is then processed
by a SQL script into its final table. I then go on to
recreate the CSV with a different DBF which has a
different header. Is there a way of reusing the same DTS
or do I have to have a separate DTS for each CSV? |