Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: Handling HRESULT 0xC020402D from BufferManager.FindColumnByLineageID

    While developing some custom transforms for my talks at the BI Conference next week , I hit a problem where I was getting an a failed HRESULT (COM Exception) in my PreExecute () method on a call to BufferManager.FindColumnByLineageID (). HRESULT 0xC020402D Which maps to DTS_E_NOBUFFERTYPEONSYNCOUTPUT...
  • Blog Post: 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, symbolic names, and descriptions for all of the...
  • Blog Post: 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 (0xC020801C...
  • Blog Post: 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(). The first argument is a reference to...
  • Blog Post: 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 (it doesn’t matter what is in it...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 is an int value which controls how you’re...
  • Blog Post: 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...
  • Blog Post: 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"...
  • Blog Post: 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 with the native COM APIs. Each post will...
Page 1 of 1 (13 items)