-
DTS 'Transform Data Task Property' GUI window
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.
-
-
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/
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|