Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Where does SQL Server store the SSIS packages?

Where does SQL Server store the SSIS packages?

like image 356
priyanka.sarkar Avatar asked Jun 28 '09 02:06

priyanka.sarkar


People also ask

Where are SQL Server packages located?

In SQL Server Data Tools (SSDT), open the Integration Services project in which you want to create a package. In Solution Explorer, right-click the SSIS Packages folder, and then click New SSIS Package. Optionally, add control flow, data flow tasks, and event handlers to the package.

Where are SSIS packages deployed?

A project, containing packages and parameters, is deployed to the SSISDB catalog on an instance of SQL Server. Packages and configurations are copied to the file system on another computer. Packages can also be saved to the MSDB database on an instance of SQL Server. CLR integration is required on the database engine.

What are the possible locations for saving the SSIS package?

In SQL Server Data Tools (SSDT) you build packages by using SSIS Designer and save the packages to the file system as XML files (. dtsx files). You can also save copies of the package XML file to the msdb database in SQL Server or to the package store.


1 Answers

Depending on how you choose to deploy them, they are either stored within the MSDB database or on the file system. Here's how you do both:

  • File System
  • Server (msdb)
like image 111
jn29098 Avatar answered Oct 23 '22 12:10

jn29098