Version of ssis installed

These components are useful for specific tasks, but the functionality of Integration Services is limited. To ensure a complete installation of Integration Services, you must select Integration Services on the Feature Selection page. If the ETL server doesn't have an instance of the Database Engine, you have to schedule or run packages from a server that does have an instance of the Database Engine.

As a result, the packages aren't running on the ETL server, but instead on the server from which they're started. As a result, the resources of the dedicated ETL server aren't being used as intended.

Furthermore, the resources of other servers may be strained by the running ETL processes. By default, in a new installation, Integration Services is configured not to log events that are related to the running of packages to the Application event log. For a complete installation of Integration Services, select the components that you need from the following list:. Integration Services. Ultimately, they ended with a replacement for DTS instead of just an upgrade and because it was such a drastic change, it was decided to name the product Integration Services instead of DTS.

Integration Services was launched with SQL Server and the most basic core functionality is still the same today. It was a drastic change with DTS and it quickly become a popular ETL due to its speed, flexibility and its support for various sources.

It introduced the concept of the project deployment model , where entire projects with their packages are deployed to a server, instead of individual packages. SSIS made it easier to configure packages and it came with a centralized storage and management utility: the catalog.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 2 years, 11 months ago. Active 2 years, 11 months ago. Viewed 16k times. However, visual studio can open. The SSIS version you have directly relates to the data engine version. Add a comment. Ask a question. Quick access. Search related threads. Remove From My Forums.

Answered by:. Archived Forums. Sign in to vote. Wednesday, July 9, AM. You can try this: Use regedit to peek at the registry.