Welcome to MSDN Blogs Sign in | Join | Help

December 2008 - Posts

Tuesday, December 30, 2008 5:17 PM

API Sample – Conditional Split

This sample creates a data flow package with an OLEDB source feeding into a Conditional Split. Items of interest: The conditional split expression is set as a property on the transform’s output. The transform also has a default output. You will get a
Posted by mmasson | 1 Comments
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 2:25 PM

API Sample - OleDB source and OleDB destination

This sample creates a data flow package with an OleDB Source component which reads from a local AdventureWorksDW2008 database, and writes to a different table in the same database using an OleDB Destination. Items of interest: The AccessMode property
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: ,
Tuesday, December 30, 2008 1:00 PM

Samples for creating SSIS packages programmatically

This is an index post for the series of posts with examples on how to create packages programmatically. Creating and adding tasks to a control flow is pretty straightforward, but programmatically adding data flow components can be tricky due to the interaction
Posted by mmasson | 0 Comments
Filed under:
Friday, December 05, 2008 9:25 AM

Performance: Top 10 Best Practices

The SQL CAT team published a Top 10 SQL Server Integration Services Best Practices list back in October, and I thought I’d draw some more attention to it incase anyone missed it the first time around. The list contains performance related tips that were
Posted by mmasson | 0 Comments
Filed under:
Thursday, December 04, 2008 5:16 PM

How to create an installer for your custom extension

The simplest way to create an installer for your custom SSIS extension is by using a Setup Project in Visual Studio. Here are the steps we take when we’re creating installers for our Codeplex projects . 1. In Visual Studio, create a new Setup Project
Posted by mmasson | 4 Comments
Filed under:
Wednesday, December 03, 2008 11:07 AM

New connectivity white papers

Two new SSIS connectivity white papers have been published on MSDN. Connectivity Options for Microsoft SQL Server 2008 Integration Services by Martin Ellis This paper talks about the various connectivity options that SSIS supports, as well as the new
Posted by mmasson | 1 Comments
Filed under:
 
Page view tracker