Skip to main content

Posts

Showing posts with the label SSIS Package deployment

How to deploy SSIS package to sql server

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