fast way to import data from db2 to sql

[alex]

Hi,
developer run insert into sql table
using open query (from db2 UDB)

7612721 row(s) affected)
run time
2h 48 minutes

Would be faster
1. export data to text file and using
import wizard to import it to sql server
2. use dts for import
3. export file and use bcp for import

thank you

Alex

[rmiao]

Dts may faster, but you need test all of them to see which one is best for you.