Adding Items to the Toolbox
Visual Studio 2012 and Later
In Visual Studio 2012 and later, the components are automatically added to the toolbox.
If you do not see the CData components, ensure you are on the Data Flow tab in the project and check the target SQL Server version of the package. You can find the version in the solution's properties under Configuration Properties > General > TargetServerVersion. The components only appear for versions of SQL Server installed on the same machine.
Visual Studio 2008
In Visual Studio 2008, you need to add the CData SAS Data Sets components to the Toolbox manually by completing the following steps:
- To add the Source and Destination, right-click anywhere in the SSIS Toolbox and select Choose Items.
- In the Choose Toolbox Items window, select the SSIS Data Flow Items tab.
- From this tab, select the CData SAS Data Sets components.