EzAPI Updated for SQL Server 2012

The EzAPI project has been updated for the SQL Server 2012 release. You can find the updated source code here. Changes Task and Component IDs updated for SQL 2012 For 2005/2008 support, please use a previous version of the code Project upgraded to .NET 4 EzProject – SSIS 2012 Project object model support Project Connection…


EzAPI – Update

I’ve just updated the Codeplex version of EzAPI – an alternative SSIS package creation API. If you missed the previous release, I definitely recommend checking it out. Updates include : Support for additional containers, tasks and components Bug fixes from the team Additional patches submitted by Codeplex users List of additional containers, tasks & components…


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 used as the index (join) columns. This is configured by using the JoinToReferenceColumn property The…


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 Package(); // Add Data Flow Task Executable dataFlowTask = package.Executables.Add("STOCK:PipelineTask"); // Set the…


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 in the sample (one is commented out). To be able to…


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 definitely be improved. Evgeny Koblov, one of the testers on the SSIS team, has put…


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("STOCK:PipelineTask"); // Set the name (otherwise it will be a random GUID value)…


New SSIS community samples

Some new samples have been added to the SSIS community samples project on codeplex. Delimited Flat File Reader This data flow source component is capable of parsing delimited flat files, including files with rows that are missing columns. Package Generation Sample This standalone executable shows how to use the SSIS object model to do schema-based…


Regular Expression Flat File Source

The RegEx flat file source is one of the new community samples for SQL Server 2008 we’ve published to Codeplex. It uses regular expressions to extract values from a text file. It works similar to the flat file source, except that it’s not limited to CSV-type files (I saw a demo where the developer who…


First two community samples for 2008 now on Codeplex

The Integration Services Community Samples project is now active on Codeplex. These samples are being created by the SSIS product team to supplement the content in books online, and the Product Samples for 2008. They will (hopefully) provide useful functionality that you can then take an customize for your ETL solutions. The first two samples…