O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

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

Create a database

This recipe, like many others in this book, requires a database to be created. It can be done by using SQL Server Management Studio. Start SSMS, connect to your local instance and right-click on the database folder. From the contextual menu, choose New Database.... The following window appears:

Fill in the Database name and click OK as we don't need to change the Owner and Database files information. You should now see the database under the Databases folder in SSMS. We're now ready to create an SSIS package that'll use it.

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