September 2, 2003 at 3:10 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?
September 2, 2003 at 3:27 pm
You can use 'dynamic property task' to override values eg out files, sql code etc.
Steven
September 3, 2003 at 1:05 am
Or you can use ActiveX Task to set each property of each task in your DTS. If you have a different headers of DBF or CSV, you must use ActiveX Task to set valid transformation.
****************************************
1: The question is ... "What is a MahnaMahna"?
2: The question is ... "Who cares?"
****************************************
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply