Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-04 : 09:41:44
|
| Rafael writes "Hi,How to iterate through DTSSource collection without knowing te column names in advance?The BOL defines DTSSource and DTSDestination as collections: "Reference the DTSDataPumpColumns collection from within transformation ActiveX scripts by referencing the DTSSource or DTSDestination collections.".I urgently need to be able to create dynamic multiphase datapump tasks where I can build the transformations based on the source and destination. I am able to set source and destination dynamically in a regular DataPump task, but cannot define the transformations dynamically. So at this point every7thing in my package is externally configurable, except for the transformations.All must be done from within ActiveXScript Tasks. Also, is there a place that shows this, the BOL does not, or gives C++/VB examples, which I am not allowed to use...Thank you in advance!" |
|
|
|
|
|
How to iterate through DTSSource collection?