Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » API   (RSS)
Monday, August 03, 2009 9:21 PM

Looking up SSIS HResult / COMException ErrorCode

The method I describe in my post about handling COMExceptions during package generation works if you have control over the package generation code, but sometimes you’ll be using third party libraries, or debugging after the fact. Note, the error codes,
Posted by mmasson | 0 Comments
Filed under:
Monday, August 03, 2009 8:27 PM

Debugging a COMException during package generation

You’ll occasionally receive a COMException when you’re programmatically generating SSIS package – typically when dealing with Data Flow components. These COM Exceptions will provide you with an HRESULT (ErrorCode), and no additional information. System.Runtime.InteropServices.COMException
Posted by mmasson | 0 Comments
Filed under:
Monday, March 02, 2009 3:14 PM

API Sample – Programmatically create and export configuration files for your packages

The previous sample shows how to add a reference to an existing configuration file. This sample shows how to create a new configuration file for a package. Things to note: The first step is to flag the property you want to export by calling DtsProperty.SetExport().
Posted by mmasson | 1 Comments
Filed under:
Monday, March 02, 2009 3:09 PM

API Sample - Programmatically add a configuration file to a package

Update 2009-03-03 : Darren Green has a post which covers the other configuration types as well . This sample programmatically adds a reference to an existing configuration file to a package. Things to note: The CreatePackage() method just creates a package
Posted by mmasson | 2 Comments
Filed under:
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 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:
 
Page view tracker