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
"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
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 - 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 - 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



Buy Now Free Trial Download Compare Editions

Task Factory SharePoint Source

The SharePoint List Source Adapter allows users to quickly connect to their SSIS packages to SharePoint servers to retrieve list and view data.

Feature Highlights

  • Easy to use UI allows for quick selection of both SharePoint lists and SharePoint views.
  • The optional filter allows the user to limit the data being retrieved from the SharePoint server.
  • UI provides a preview data option to verify the data being retrieve is correct.
Sharepoint Source

Sharepoint Source - Step 1
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 Source - Step 2
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 Source - Step 3
The next step is to choose a list from your sharepoint server.

The next step is to choose a list from your sharepoint server.

Sharepoint Source - Step 4

After a list is chosen, there are a couple of optional settings that can be set to restrict the data being pulled from the sharepoint list.

First is the list view. To use a view, simply select the view from the "Select view" drop down list.

After a list is chosen, there are a couple of optional settings that can be set to restrict the data being pulled from the sharepoint list.

First is the list view. To use a view, simply select the view from the "Select view" drop down list.

Sharepoint Source - Step 5
The other option for filtering is to use the Filter control. The filter control allows the user to create custom filters on the data returned from the server.

To add a new filter, click the + sign next to the "And" group indictor.

The other option for filtering is to use the Filter control. The filter control allows the user to create custom filters on the data returned from the server.

To add a new filter, click the + sign next to the "And" group indictor.

Sharepoint Source - Step 6
This will add a default filter

This will add a default filter

Sharepoint Source - Step 7
To change the column that will be used in the filter, simply click the column name which is labeled as "Title" above. This will bring up a list of column names to choose from.

To change the column that will be used in the filter, simply click the column name which is labeled as "Title" above. This will bring up a list of column names to choose from.

Sharepoint Source - Step 8

Next, you can choose the operand (begins with, contains, is not null, etc) used in the filter. 

Then, depending on the data type and operand chosen, you can add the filter value. Below are the three options available when adding a filter value

Next, you can choose the operand (begins with, contains, is not null, etc) used in the filter. 

Then, depending on the data type and operand chosen, you can add the filter value. Below are the three options available when adding a filter value

Sharepoint Source - Step 9

Text Value

Text Value

Sharepoint Source - Step 10

Numeric value

Numeric value

Sharepoint Source - Step 11

Choices value (drop down list)

Choices value (drop down list)

Sharepoint Source - Step 12
If more than one filter is desired simply click the + sign again to add another filter. There is a limit of two filters per group.

To verify the filters are working correctly, click the "Preview" button. The preview button brings back ONLY the first 10 rows of data from a list.

Click OK to save the Sharepoint Source Settings.

If more than one filter is desired simply click the + sign again to add another filter. There is a limit of two filters per group.

To verify the filters are working correctly, click the "Preview" button. The preview button brings back ONLY the first 10 rows of data from a list.

Click OK to save the Sharepoint Source Settings.

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