Hi I have a database in DB2 and i would like to import this data into sql server 2000. How can i do that?
Thanks.DTS. Data Transformation Services. In enterprise manager go to Tools--> Data Transformation Services.|||what should be the data source when we import data from db2 using dts.
thanks.|||You need to have an ODBC datasource, or better an OLE DB provider installed for DB2, eventually using CAE.|||I dont have ODBC datasource, or better an OLE DB provider installed for DB2.Do I need to install these implicitly?But i have OLE DB provider for oracle on my server.Where can i get the oledb provider for db2?
Thanks.|||http://www-306.ibm.com/software/data/db2/udb/ad/v7/oledb.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment