![]() You access the SSISDB database in SQL Server Management Studio by expanding the Databases node in Object Explorer. You access the SSISDB catalog in SQL Server Management Studio by connecting to the SQL Server Database Engine and then expanding the Integration Services Catalogs node in Object Explorer. For examples of how to use Windows PowerShell to complete tasks such as deploying a project, see the blog entry, SSIS and PowerShell in SQL Server 2012, on .įor more information about viewing operations data, see Monitor Running Package and Other Operations. For more information about using SQL Server with Windows PowerShell, see SQL Server PowerShell. The SSISDB catalog and the SSISDB database support Windows PowerShell. For information about creating maintenance plans, see Maintenance Plans. To maintain the SSISDB database, it is recommended that you apply standard enterprise policies for managing user databases. In many cases, the same task can be performed in the UI or by calling a stored procedure. ![]() You manage the objects by calling stored procedures in the SSISDB database or by using the UI of the SSISDB catalog. You inspect objects, settings, and operational data that are stored in the SSISDB catalog, by querying the views in the SSISDB database. The objects that are stored in the SSISDB catalog include projects, packages, parameters, environments, and operational history. For more info, see Extract, transform, and load data on Linux with SSIS. ![]() For more info, see Lift and shift SQL Server Integration Services workloads to the cloud.Īlthough you can also run SSIS packages on Linux, the SSIS Catalog is not supported on Linux. ![]() You can also create the SSIS Catalog in Azure SQL Database, and deploy and run SSIS packages in Azure. This article describes the SSIS Catalog in general, and the SSIS Catalog running on premises. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |