SQLSrvIntegrationSrv Release Rss Feed

Updated Release: SharePoint List Source and Destination (Mar 17, 2009)

kevinidzi — Thu, 19 Mar 2009 22:17:29 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Note: Currently this adapter works with English (en-US) SharePoint server culture settings only. Feel free to contribute if you want to add more support!

UPDATE - 3/18/2009
1) Hotfix update.

UPDATE - 3/17/2009
1) Fixed support for multi-line text to be retrieved from SharePoint as NTEXT (there was a bug in previous attempt at this)
2) Added ability for user to rename source/destination columns and have the names remain even after refreshing the sharepoint list from the source (to pull in new columns or something)
3) Updated it so that numeric values from SharePoint will come into SSIS as null if they are null, vs being translated to a 0
4) This release will fix an issue with prior release's version # making it a breaking change for SSIS Packages

UPDATE - 2/11/2009:
1) Support wide lists with lots of data in a column.
2) Support multi-row text columns up to 2 bil chars
3) Added Culture to allow proper formatting of numbers/dates on external systems in different languages
4) Changed validation so that if a column is ADDED to sharepoint, it will not cause a validation error, only if a needed column is removed (helps with lists where people are adjusting them after you sync a process to them)
5) Fixed bug in datatyping where the data was being written using the wrong datatype (R8 Issue)

Also - The SharePointUtility.DLL has been added as a separate download to facilitate using it to access SharePoint Lists API without requiring the entire MSI.

Written by Kevin Idzi

Released: SharePoint List Source and Destination (Mar 17, 2009)

Thu, 19 Mar 2009 22:17:29 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Updated Release: SharePoint List Source and Destination (Mar 17, 2009)

kevinidzi — Thu, 19 Mar 2009 20:36:50 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Released: SharePoint List Source and Destination (Mar 17, 2009)

Thu, 19 Mar 2009 20:36:50 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Updated Release: SharePoint List Source and Destination (Mar 17, 2009)

kevinidzi — Thu, 19 Mar 2009 17:59:39 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Released: SharePoint List Source and Destination (Mar 17, 2009)

Thu, 19 Mar 2009 17:59:39 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Updated Release: SharePoint List Source and Destination (Mar 17, 2009)

kevinidzi — Tue, 17 Mar 2009 18:42:04 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Note: Currently this adapter works with English (en-US) SharePoint server culture settings only. Feel free to contribute if you want to add more support!

UPDATE - 3/17/2009
1) Fixed support for multi-line text to be retrieved from SharePoint as NTEXT (there was a bug in previous attempt at this)
2) Added ability for user to rename source/destination columns and have the names remain even after refreshing the sharepoint list from the source (to pull in new columns or something)
3) Updated it so that numeric values from SharePoint will come into SSIS as null if they are null, vs being translated to a 0
4) This release will fix an issue with prior release's version # making it a breaking change for SSIS Packages

UPDATE - 2/11/2009:
1) Support wide lists with lots of data in a column.
2) Support multi-row text columns up to 2 bil chars
3) Added Culture to allow proper formatting of numbers/dates on external systems in different languages
4) Changed validation so that if a column is ADDED to sharepoint, it will not cause a validation error, only if a needed column is removed (helps with lists where people are adjusting them after you sync a process to them)
5) Fixed bug in datatyping where the data was being written using the wrong datatype (R8 Issue)

Also - The SharePointUtility.DLL has been added as a separate download to facilitate using it to access SharePoint Lists API without requiring the entire MSI.

Written by Kevin Idzi

Released: SharePoint List Source and Destination (Mar 17, 2009)

Tue, 17 Mar 2009 18:42:04 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Updated Release: SharePoint List Source and Destination (Feb 11, 2009)

kevinidzi — Tue, 17 Feb 2009 18:46:29 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Note: Currently this adapter works with English (en-US) SharePoint server culture settings only. Feel free to contribute if you want to add more support!

UPDATE - 2/11/2009:
1) Support wide lists with lots of data in a column.
2) Support multi-row text columns up to 2 bil chars
3) Added Culture to allow proper formatting of numbers/dates on external systems in different languages
4) Changed validation so that if a column is ADDED to sharepoint, it will not cause a validation error, only if a needed column is removed (helps with lists where people are adjusting them after you sync a process to them)
5) Fixed bug in datatyping where the data was being written using the wrong datatype (R8 Issue)

Also - The SharePointUtility.DLL has been added as a separate download to facilitate using it to access SharePoint Lists API without requiring the entire MSI.

Written by Kevin Idzi

Released: SharePoint List Source and Destination (Feb 11, 2009)

Tue, 17 Feb 2009 18:46:29 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Updated Release: SharePoint List Source and Destination (Feb 11, 2009)

kevinidzi — Wed, 11 Feb 2009 08:12:29 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Released: SharePoint List Source and Destination (Feb 11, 2009)

Wed, 11 Feb 2009 08:12:29 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Updated Release: SharePoint List Source and Destination (Feb 11, 2009)

kevinidzi — Wed, 11 Feb 2009 08:09:24 GMT

SharePoint List Source and Destination Sample

MSDN Tutorial
This sample demonstrates how to get data into and out of SharePoint lists by using custom source and destination adapters written in C# 3.0. Use this sample to learn more about:

Extensive Validation: Validation for this component actively goes against the SharePoint Site to verify the properties are valid.
Values from Expressions: This component supports external variables, which can be expressions, and can be attached to the source component to customize the query. Similar to the CommandText for the other Sql Components
Linq: The Component has been written using Linq with .net 3.5 and shows how elements such as the metadata and columns can be combined to create a readable usage in a Linq format.
Custom properties: The component keeps its configuration in custom properties on itself, inputs, and input columns.

Note: Currently this adapter works with English (en-US) SharePoint server culture settings only. Feel free to contribute if you want to add more support!

Written by Kevin Idzi

Reviewed: EzAPI - Package Generation API (Jan 09, 2009)

alejanmi — Fri, 09 Jan 2009 14:26:53 GMT

Rated 5 Stars (out of 5) - This EzAPI is an absolute great. Being able to create template classes, use inheritance for creating complex ETL patterns in code and enable the use of generics (e.g.: replace transform (EzComponents) with any T. is elegant. Great fresh sagway to use SSIS API. Great work you all! Please keep it up! There are a few minor issues in the .mht file (documentation), but they are ok in the SSIS team blog

Updated Release: EzAPI - Package Generation API (Dec 30, 2008)

mmasson — Wed, 31 Dec 2008 19:29:41 GMT

EzAPI - Package generation API

This sample provides some functionality to easily create SSIS packages programmatically and dynamically alter their objects (tasks, components, changing metadata, connection strings, etc). This framework supports:

Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)

For more information, see the post on the SSIS team blog.

Written by Evgeny Koblov

Released: EzAPI - Package Generation API (Dec 30, 2008)

Wed, 31 Dec 2008 19:29:41 GMT

EzAPI - Package generation API

Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)

For more information, see the post on the SSIS team blog.

Written by Evgeny Koblov

Updated Release: EzAPI - Package Generation API (Dec 30, 2008)

mmasson — Tue, 30 Dec 2008 21:21:31 GMT

EzAPI - Package generation API

Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)

For more information, see the post on the SSIS team blog.

Written by Evgeny Koblov

Released: EzAPI - Package Generation API (Dec 30, 2008)

Tue, 30 Dec 2008 21:21:29 GMT

EzAPI - Package generation API

Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)

For more information, see the post on the SSIS team blog.

Written by Evgeny Koblov

Updated Release: EzAPI - Package generation API (Dec 30, 2008)

mmasson — Tue, 30 Dec 2008 21:21:15 GMT

EzAPI - Package generation API

Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)

For more information, see the post on the SSIS team blog.

Written by Evgeny Koblov

Created Release: EzAPI - Package generation API (Dec 30, 2008)

mmasson — Tue, 30 Dec 2008 21:16:24 GMT

EzAPI - Package generation API

Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)

Written by Evgeny Koblov