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.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS: Dynamic Data Pump Source & Destination fields

Author  Topic  krsk Starting Member 21 Posts Posted - 2003-03-24 : 03:19:46 Hi I would like to do this: Set the source and destination properties in the [Dynamic properties task] from a random table definition. I know how to manipulate the properties, but I have to do it from the table definition and not from static code. The reason is to avoid errors in the data pump transform statement when the base table definition changes. Does anyone have a ActiveX script that dose this? So the execution plan would look something like this: - Get table definition - Drop old table - Create new table - Set the correct source and destination properties in the Data Pump statement - Load the data Another thing: What would be the easiest way to get the table definition? Table is not in a MS SQL so I need a connection...and maybe somehow place the result in a globalvariable or ??? /Kristian :-) Edited by - merkin on 03/24/2003 03:28:13 Edited by - krsk on 03/24/2003 04:06:02 Edited by - krsk on 03/25/2003 02:48:52