Installation and Configuration

The installation steps include the following:

1. Copy the main assembly to the appropriate component folder under the 64-bit Program Files folder.

2. Install the appropriate assemblies in the global assembly cache (GAC).

3. Stop and restart the SSIS service (because it caches the list of installed components).

4. Restart SSDT, and BIDS or Visual Studio.

5. If necessary, make manual adjustments to the list of custom components in the Toolbox.

Note: If repository settings are not available in SSIS, then install Newtonsoft assemblies from the <AVEVA Work Tasks Installation Path>\Bin folder to the global assembly cache (GAC).

SQL Server Client Components

6. Copy Skelta.SSIS.Pipeline.ListDestination.dll and Skelta.SSIS.Pipeline.ListSource.dll to C:\Program Files\Microsoft SQL Server\<<SQL Server Version Number>>\DTS\PipelineComponents\.

   For <<SQL Server Version Number>> refer to File Locations for Default and Named Instances of SQL Server.

7. Register the DLL files to Assembly GAC. Refer to Install an Assembly into the Global Assembly Cache.

Configure List integration components

After the installation, add the List Integration component to the Toolbox by following the steps below:

8. Create a new SSIS project.

9. Drag and drop a Data Flow task.

10. Add the component to the Toolbox.

Configure List Destination component

11. Create a new SSIS project.

12. Start Visual Studio.

13. Click File > New > Project > Business Intelligence Projects > Integration Service Project.

14. Enter Project Name.

15. Select OK to create the project. A blank Control Flow is created.

16. Drag and drop a Data Flow Task item into the Control Flow.

17. Double-click on the task to switch to the data flow view.

18. Go to the Toolbox of the Data Flow Sources and in the select XML Source drop-down list, check the List View option.

    You can see the List Source under the Data Flow Sources and List Destination under Data Flow Destinations.