Sample solution in Visual Studio

For this section, we'll need an existing installation of Visual Studio 2015 or 2017 and SQL Server Data Tools (SSDT) installed. Visual Studio is available at https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017.

Once SSDT is opened, click on FILE | New | Project...:

Visual Studio (SSDT)

The New Project window appears. Select Integration Services Import Project Wizard, type WWImportersDaily in the textbox beside Name, and click on OK:

The Integration Services Import Project Wizard window opens, as shown in the following screenshot. Click on Next to proceed to the next step:



In the Select Source window, select the Project deployment file radio button, and click on Browse.... The Open file window appears. Navigate to the folder where the SSIS sample file, .ispac, has been downloaded, and click on Open:

Once back on the wizard, click Next to proceed to the next step.

In the Review window, click the Import button.

Once the project has been imported, you can see it in the Solution Explorer:

You will have to modify the two connection managers if your server is not the default instance on your server. To do so, double-click on each connection manager, WWI_DW_Destination_DW.conmgr and WWI_Source_DB.conmgr, and change their server properties.

If the connections are online, we can run the package and see if everything is working fine.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.128.78.30