Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Samples » API   (RSS)
Friday, January 02, 2009 10:34 AM

API Sample – Lookup Transform

This sample creates a data flow package with an OLEDB Source component feeding into a Lookup Transform. The Lookup transform is set to Full Cache mode, and uses [DimCustomer] as its reference table. Items of interest: CustomerKey and GeographyKey are
Posted by mmasson | 3 Comments
Filed under: , ,
Tuesday, December 30, 2008 2:47 PM

API Sample – Row Count Transform

This sample creates a data flow package with an OLEDB Source that feeds into a Row Count transform. The Row Count transform is configured to store the result in the RowCountVar package variable. static void Main( string [] args) { Package package = new
Posted by mmasson | 3 Comments
Filed under: ,
Tuesday, December 30, 2008 2:38 PM

API Sample – ADO.Net Source

This sample creates a data flow package with an ADO.Net source. Items of interest: The AccessMode property is similar to that of the OleDB Source , except it only has two values – 0 for TableOrViewName, and 2 for SqlCommand. Examples of both are included
Posted by mmasson | 2 Comments
Filed under: ,
Tuesday, December 30, 2008 1:20 PM

EzAPI – Alternative package creation API

SSIS provides APIs to programmatically create dtsx packages. While we provide a managed wrapper layer for the runtime/control flow, you have to use the lower level COM wrappers (DTSPipelineWrap) to create your data flows – the usability of which could
Posted by mmasson | 1 Comments
Filed under: ,
Tuesday, December 30, 2008 1:01 PM

API Sample - Create a package with a data flow task

This code creates a package with a single data flow task. It will be used as a base for the more complicated code samples. static void Main( string [] args) { Package package = new Package (); // Add Data Flow Task Executable dataFlowTask = package.Executables.Add(
Posted by mmasson | 3 Comments
Filed under: ,
 
Page view tracker