How to Look in an SSIS Package in an XML

You can access an SSIS package through the SQL Server Management Studio.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server Database. You can use and create SSIS packages to copy files, send email messages, update data warehouses and mine data. Extensible Markup Language, or XML, is a programming language used to store and transport data. SSIS packages are stored as XML files on the database. You can look at the package in its XML format through the SQL Server Management Studio, and open it through its "Stored Packages" feature.

Instructions

1. Click "Start," "All Programs," and click "SQL Server Management Studio." Log in with your SQL Server administrator's username and password.

2. Click "Server Integration Services."

3. Click "Stored Packages," "MSDB."

4. Right-click the SSIS file you want to look at and click "Export." You will be able to view your SSIS package in its XML format.

Resources

• MSDN: SQL Server Integration Services
• W3 Schools: XML Tutorial