<div>
<div class="content wysiwyg-content">
Hi guys, <br />
<br />
What is the difference between an SSIS solution, a project, and a package? Can I save a package file outside of the default folder structure for SSIS? If I do, does the project/solution information come with it? Can I name my project with a special name? It looks like it always says &quot;Package.dtsx&quot;, can I change that?
</div>
</div>


Hi guys, 

What is the difference between an SSIS solution, a project, and a package? Can I save a package file outside of the default folder structure for SSIS? If I do, does the project/solution information come with it? Can I name my project with a special name? It looks like it always says "Package.dtsx", can I change that?

SSIS packages - project vs package, how to save, basics

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.