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?
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!
Member
40 Points
162 Posts
How to build a SSIS package by VS to load data from DB2 and output a CSV file?
May 14, 2020 12:12 PM|zhao790|LINK
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!
All-Star
47661 Points
20887 Posts
Re: How to build a SSIS package by VS to load data from DB2 and output a CSV file?
May 14, 2020 12:34 PM|mgebhard|LINK
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.
Member
40 Points
162 Posts
Re: How to build a SSIS package by VS to load data from DB2 and output a CSV file?
May 14, 2020 12:41 PM|zhao790|LINK
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!
All-Star
47661 Points
20887 Posts
Re: How to build a SSIS package by VS to load data from DB2 and output a CSV file?
May 14, 2020 01:04 PM|mgebhard|LINK
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
Great. Then all you have to do is query DB2.