DTS in VB6

KWLB
12-15-2000, 09:27 AM
I've created a DTS package using the DTS library in VB. Want to add a simple data pump task at runtime.
Only need to copy a table from one database to another on the same server.

I don't want to have to create a detailed DTS.Transformation object which includes create table and maps all the fields. All I want is to say this is the source table A and the name of the destination table to create is B.

Any gurus for this stuff??

whelanp
12-18-2000, 09:46 AM
Check out the ScriptTransfer and Transfer methods.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum