O'Reilly logo

SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Hands-On Exercise: Creating and Testing a Package that Uses a Transfer Database Task

In order to follow the steps as indicated, you will need a Transfer Database Task, the ability to make connection to the two servers, and the required permissions. In this exercise, the pubs database on the SQL Server 2000 on a networked computer, Computer 1 (XPHTEK in this example), will be copied over to the SQL Server 2005 Express on the Computer 2 (Hodentek in this example), on which the Visual Studio 2005 is also installed. If pubs are not available for some reason, any other database may be used. In addition to the SQL Server 2005 Express, Computer 2 also has an SQL Server 2005 Standard Edition installed.

Step 1: Creating a Network Share on Computer ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required