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: 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...
  • 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: 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: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Creating a custom task with a default UI

    The Developing a User Interface for a Custom Task entry in Books Online describes how to build your UI from scratch, but there is an easier way to create a UI that has the same look and feel as the stock tasks that ship with SSIS. The Microsoft.DataTransformationServices.Controls assembly exposes a base...
  • Blog Post: MDDE appears on Codeplex

    The SQL Server Metadata-Driven ETL Studio (MDDE) was an internal MSIT project first shown at the MS BI Conference last year. The initial release is now up on Codeplex . There isn't much information up about it yet, but I'm told that docs and examples should be appearing soon. Essentially what MDDE gives...
  • Blog Post: Real world scenarios

    May has been a busy month! The first Microsoft Business Intelligence conference was earlier in the month, and it seemed to be a big success. I was amazed at how many people were there, and I met a lot of interesting people when I was manning the demo booth and Ask The Experts table we had setup in...
  • Blog Post: Roll your own Transfer SQL Server Objects task

    Awhile back we went through a lot of customer feedback logged through the Connect site concerning the Transfer SQL Server Objects task. Some of these turned out to be bugs, but a lot of the reported issues stemmed from usability problems with the task itself. There's actually not that much to the task...
  • Blog Post: SQL Server on Codeplex

    SQL Server now has its own section on codeplex (Microsoft's open source project hosting site). This site includes all of the samples that come with SP2, in a single-serve format. Each product has a section, so you can grab samples for individual products instead of running the monolithic samples installer...
Page 1 of 1 (15 items)