Click here to Skip to main content
15,887,027 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I have two servers one server have sql server database and another server have db2 database

I need to read data from db2 database on server A then after read it insert it into sql server database that exist on server B

I use sql server 2017

so can you give me How to create ssis package to make that by details

I not working on ssis package before so if you can give me answer by more details will be better ?

What I have tried:

How to make ssis package by details read data from db2 database and insert it o sql server database
Posted
Updated 9-Aug-23 22:09pm

1 solution

You can find a step-by-step on how to create the SSIS Package, starting at lesson 1 - MS Learn | Create a new Integration Services project[^]

Quote:
1) On the Windows Start menu, search for and select Visual Studio (SSDT).

2) In Visual Studio, select File > New > Project to create a new Integration Services project.

3) In the New Project dialog box, expand the Business Intelligence node under Installed, and select Integration Services Project in the Templates pane.

4) In the Name box, change the default name to SSIS Tutorial. To use a folder that already exists, clear the Create directory for solution check box.

5) Accept the default location, or select Browse to browse to locate the folder you want to use. In the Project Location dialog box, select the folder and then Select Folder.

6) Select OK.

7) By default, an empty package titled Package.dtsx is created and added to your project under SSIS Packages.

8) In Solution Explorer, right-click Package.dtsx, select Rename, and rename the default package to Lesson 1.dtsx.


After this, follow the link to the next steps.
 
Share this answer
 
v3
Comments
Andre Oosthuizen 10-Aug-23 4:13am    
Damn, only realized now who the poster is.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900