How to build a SSIS package by VS to load data from DB2 and output a CSV file?

Question

User-609535877 posted

I got an assignment to build a SSIS package by Visual Studio to get data from DB2 and produce a CSV file, with which I am not familiar. Currently in SQL server we set up a link server to DB2 and can query the data.

Can someone give me some idea or sample how to build this SSIS package?

Thanks in advance!

Answer 1

User475983607 posted

zhao790

Can someone give me some idea or sample how to build this SSIS package?

Have you tried creating an SSIS project, connecting to DB2, and are having a problem?  Do you have the DB2 driver installed?

Please explain what you have done up to this point.

Answer 2

User-609535877 posted

I haven't started this my first SSIS package yet and no clear idea how to build it. I can query DB2 data by linker server in SQL server Management studio. Thanks!

Answer 3

User475983607 posted

zhao790

I haven't started this my first SSIS package yet and no clear idea how to build it. 

I prefer to go through a Getting Started tutorial when I'm not familiar with a technology.  

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-tutorials?view=sql-server-ver15

zhao790

I can query DB2 data by linker server in SQL server Management studio.

Great. Then all you have to do is query DB2.