mutley
May 22nd, 2000, 11:08 PM
Can I choose the tables and order from the migration:
eg:
I have 2 database (informix,sqlserver), I want export from informix to sqlserver many tables. I want choose that is first, second...etc e too the tables
INFORMIX SQL SERVER
TABLE01 TABLE02
TABLE02 TABLE03
TABLE03 TABLE03
TABLE04 TABLE04
I want first the tables : table04,tabl03,table01 and I do not want the table TABLE02, have I choose ?
Dim oPkg As new DTS.Package
oPkg.LoadFromSQLServer ".", "", "", _ DTSSQLStgFlag_UseTrustedCnnection, "", _
"", "", "mypack"
oPkg.Execute
eg:
I have 2 database (informix,sqlserver), I want export from informix to sqlserver many tables. I want choose that is first, second...etc e too the tables
INFORMIX SQL SERVER
TABLE01 TABLE02
TABLE02 TABLE03
TABLE03 TABLE03
TABLE04 TABLE04
I want first the tables : table04,tabl03,table01 and I do not want the table TABLE02, have I choose ?
Dim oPkg As new DTS.Package
oPkg.LoadFromSQLServer ".", "", "", _ DTSSQLStgFlag_UseTrustedCnnection, "", _
"", "", "mypack"
oPkg.Execute