Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Chrishull
Starting Member
2 Posts |
 Posted - 2008-08-05 : 15:46:30
|
| Hi There,I have been trying to insert a list of numbers from a SQL 2005 table into a DB2 table. Both servers are not local.I can extract data from DB2 into SQL2005. I thought it would be as simple as flipping the process but I'm wrong.Any help would be greatly appreciated!Thanks,Chris |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-05 : 15:49:41
|
| Could you describe your extract? Can DB2 import data from a file? Do you have a linked server setup between the two? How about an SSIS package?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
Chrishull
Starting Member
2 Posts |
Posted - 2008-08-05 : 15:55:47
|
| I have a couple DB2 of tables that I have permissions to add to. I want to take my SQL results and insert them into a DB2 tableINSERT INTO DB2.QUERY_SET_12SELECT DISTINCT NUMBER FROM SQL2005_TABLEWe just recently migrated from SQL2000 to SQL2005. I know that I can still use the DTS package but I would like to be able to use the SSIS package. I haven't gone for SSIS training yet but I understand the concept of the SSIS data flow process... I just don't know what the proper data flow source, transformation, destinations to use.Thanks for the help! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-07 : 23:20:36
|
| Did you get any error? Did you create data source for db2? Don't think DB2.QUERY_SET_12 is correct notation, package may try to find table QUERY_SET_12 in db DB2 on sql server. |
|
|
|
|
|
|
SQL 2005 to DB2