Printable View
I am importing data from xls file to a db table with a dts. In the time of the dts creation I am using 'Transform Data Task Properties' GUI window to map incoming xls fields (source) to the table columns (destination).
Question: Is there any way to invoke the 'Transform Data Task Property' GUI window in dts runtime and use it to change the mapping dynamically in the run time?
Thanks, Vadim.
Not as I aware of.
You should be able to do this. I suggest that you have a look in the Wrox Press book called "Professional SQL Server 2000 DTS".
However, just because you can do something doesn't mean you should. Dynamically adding datapumps needs a lot of thought and testing it could be an "interesting" task.
I also recommend the wrox book on DTS. You can easily modify DTS package using VBScript.
Other source for dts is http://www.sqldts.com/