Frequently Asked Questions

Community Products

Installation

Community Products

What are community components?

Community Components is the term we use for products that we have written and made available to the community on a "AS IS" and free to use basis. We strongly support the Microsoft SQL Server Community in its many forms, and this is just one of the ways we contribute.

Community Components are available free of charge from SQLIS.com, our free community resource site. All our releases are digitally signed by "Konesans Limited" so you can be sure you are installing safe and secure software direct from us. Please note that our free resources are still subject to copyright and usage is subject to acceptance and bound by the accompanying license.

top

How are community products licensed?

Community products are normally bound by a standard license agreement. Each component is packaged as a Windows Installer package for ease of installation, during which you will be prompted to accept the license agreement for the component.

View the standard Community License.

top

 

Can I use community components in a commercial development or application?

Yes. You are not allowed to sell the components themselves. If you deliver packages that use the components, and have added value and benefit by building a package for a function then you are delivering a larger solution. Your services can use our component, but they must be used as part of a larger system, and not be the most significant factor. If you are still unsure, then please contact us, and describe how you intend to use them.

View the standard Community License.

top

 

Installation

How do I install a task or data flow component?

All products are supplied as Windows Installer packages (MSI). These can be run directly to install the component. If the component is already installed, an alternative screen will be presented allowing you to repair and installation or remove the product. Products can also be uninstalled through Programs and Feature or Apps & features options in Windows.

Installation requires administrative level privileges as SSIS components need to be installed in the Global Assembly Cache (GAC) of the local machine, you will be prompted for this if required.

Once the installation is complete the task or transformation should be available to choose in the SSIS Toolbox alongside the stock components from Microsoft.

If you have issues with the component not being available in the toolbox, please try the steps below.

  • Ensure that you are installing the component locally, the machine running Visual Studio that you will use to develop your SSIS packages.
  • Check that you have installed the correct version of the component for your version of SQL Server.
  • Check the project properties for the Target Server Version, Configuration Properties. This is a reverse check that you really are tageting the version of SQL Server you think you are.
  • Right-clcik teh toolsbox and choose Refresh Toolbox.
  • Check that installation has worked, and the file is available in the GAC
  • Check that file is available in components folder. For a SQL Server 2016 task check C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Tasks. For a SQL Server 2014 data flow component check C:\Program Files (x86)\Microsoft SQL Server\120\DTS\PipelineComponents. Just change the folder based on the target SQL Server version, and Tasks vs PipelineComponents.

 

top

Which version do I install?

Most of the components will offer several diferent downloads, each for specific version of SQL Server. Each installer is aligned to a particular version of SQL Server, e.g. File Watcher Task for SQL Server 2016.

For recent versions of SQL Server development tools you can target different versions of SQL Server, please ensure you install the component aligned to the SQL Server version which the project is targeting. i.e. You may have installed the SQL Server 2016 tools (16.5), but if the project target version is SQL Server 2014, then that make sure you install the SQL Server 2014 version of the component.