Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources


Buy Now Free Trial Download Compare Editions

Task Factory SharePoint Destination Adapter

The SharePoint List Destination Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to send data to lists.

Feature Highlights

  • Easy to use UI allows for quick mapping of fields from local source data to to SharePoint list columns.
SharePoint List Destination Adapter

SharePoint List Destination Adapter- Step 1
The easy to use UI of the SSIS Sharepoint Destination allows the user to quickly connect to an SSIS Sharepoint  server and start using SSIS Sharepoint Destination  within SSIS in a matter of minutes. Here is an overview on how to configure the SSIS Sharepoint Destination.

The easy to use UI of the SSIS Sharepoint Destination allows the user to quickly connect to an SSIS Sharepoint  server and start using SSIS Sharepoint Destination  within SSIS in a matter of minutes. Here is an overview on how to configure the SSIS Sharepoint Destination.

SharePoint List Destination Adapter- Step 2

The first step is to choose or create a sharepoint connection manager. Either select an existing connection manager or click "Create New Sharepoint Connection..."


The first step is to choose or create a sharepoint connection manager. Either select an existing connection manager or click "Create New Sharepoint Connection..."


SharePoint List Destination Adapter- Step 3

If you select "Create New Sharepoint Connection..." then the "TF Sharepoint Connection" window will appear. You will need to fill in the login information for your sharepoint server. Click "Test connection" before saving to verify the connection is valid.


If you select "Create New Sharepoint Connection..." then the "TF Sharepoint Connection" window will appear. You will need to fill in the login information for your sharepoint server. Click "Test connection" before saving to verify the connection is valid.


SharePoint List Destination Adapter- Step 4

Next the Destination list must be selected. This is the list where data is being sent to on the SharePoint server.


Next the Destination list must be selected. This is the list where data is being sent to on the SharePoint server.


SharePoint List Destination Adapter- Step 5

After a list is chosen, an Action must be selected. There are three options for actions

1) Create - This action will create rows in the selected list

2) Update - This action will update rows in the selected list

3) Delete - This action will delete rows in the selected list

After a list is chosen, an Action must be selected. There are three options for actions

1) Create - This action will create rows in the selected list

2) Update - This action will update rows in the selected list

3) Delete - This action will delete rows in the selected list

SharePoint List Destination Adapter- Step 6

Now the columns being sent from the source to the sharepoint list need to be mapped. To do this, simply click on the Input Column and select a column from the source to map it to the column in the destination.


Now the columns being sent from the source to the sharepoint list need to be mapped. To do this, simply click on the Input Column and select a column from the source to map it to the column in the destination.


SharePoint List Destination Adapter- Step 7

After a column is mapped, it will be highlighted in green.


After a column is mapped, it will be highlighted in green.


SharePoint List Destination Adapter- Step 8

When mapping columns for the updates and deletes, the ID column in the destination must be mapped to a source column.

Update mappings:


When mapping columns for the updates and deletes, the ID column in the destination must be mapped to a source column.

Update mappings:


SharePoint List Destination Adapter- Step 9

Delete mappings (only ID is available):

Delete mappings (only ID is available):

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works