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??
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??