how to transfer the tables from sql server database to db2 data base using ssis

Question

Hello Everyone,

i am new to ssis my question is how to move the sqlserver tables to db2 database using ssis packages

Answer 1

Hello Everyone,

i am new to ssis my question is how to move the sqlserver tables to db2 database using ssis packages

plz help me

Answer 2

Are  you talking about AS400? Did you make sure that table definition/data types are compatible with DB2?

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 3

Thanks for reply

my question is my source database is sql server, in this i have 50 tables, my requirement is to transfer the 50 tables into db2 data base(destination database). how i can achive this

Answer 4

Hello,

Please use the following link to create a linked server on SQL Server. You will have to install the IBM ODBC driver first from the IBM media.

http://www.sqlcoffee.com/Tips0013.htm

Once the linked server is created, you can use Integration Services, OpenQuery or EXEC to transfer the tables.

Hope this helps.   
 
Regards,

Alberto Morillo
SQLCoffee.com

Answer 5

Thanks Alberto

But in my organization we r using sqlserver 2005 and by using linked server the table is stored in sqlserver mangement studio, but my requirement is to move the tables from sqlserver database to DB2 database using ssis packages if u possible plz provide one sample example for me

thanks in advance

Answer 6

Thanks Alberto

But in my organization we r using sqlserver 2005 and by using linked server the table is stored in sqlserver mangement studio, but my requirement is to move the tables from sqlserver database to DB2 database using ssis packages if u possible plz provide one sample example for me

thanks in advance

You may post this question in SSIS forum: http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/threads.

---

Best Regards,
Chunsong Feng

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.