Problem If you open or create a .NET Core project and Visual Studio cannot find the corresponding .NET Core SDK, you'll get a dialog box similar to the following:
When we are ready to deploy our packages we have the following options available: Deploy to the file system Deploy to the package store Deploy to SQL Server The simplest approach to deployment is probably to deploy to the file system. As SSIS package is actually just an XML file and it can simply be copied from its project location to a folder on the deployment target. SSIS packages deployed to SQL Server are stored in the msdb database. Follow below steps to deploy SSIS package in SQL Server