Create a simple project

This recipe will show you how to create an SSIS project to be able to use the custom logging level that we just created in the previous part of the recipe.

First, start SQL Server Data Tools and create a new Integration Services project: File | New | Integration Services Project. The following screenshot suggests how the project can be named:

Once the project has been created, we should see a package called Package.dtsx. We'll right-click on it and select Rename, as shown in the following screenshot:

We'll name it

Get SQL Server 2017 Integration Services Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.