Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Samples   (RSS)
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 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: ,
Thursday, September 25, 2008 3:16 PM

SQL Server Data Services connectors now on Codeplex

When I was visiting the SSIS development team in Shanghai a couple of months ago, we started working on a side project to create Source and Destination components for SQL Server Data Services (SSDS). We developed them as samples, and I was surprised at
Posted by mmasson | 2 Comments
Filed under: ,
Tuesday, August 19, 2008 9:56 AM

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
Posted by mmasson | 2 Comments
Filed under:
Wednesday, July 23, 2008 8:52 PM

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
Posted by mmasson | 2 Comments
Filed under:
Wednesday, July 23, 2008 3:34 PM

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
Posted by mmasson | 1 Comments
Filed under: ,
Friday, July 18, 2008 6:20 PM

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
Posted by mmasson | 4 Comments
Filed under: ,
Friday, March 21, 2008 10:38 PM

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
Posted by mmasson | 4 Comments
Filed under: , ,
Friday, June 01, 2007 10:14 AM

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
Posted by mmasson | 2 Comments
Filed under: ,
Wednesday, April 18, 2007 4:08 PM

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
Posted by mmasson | 12 Comments
Filed under: , ,
Thursday, March 29, 2007 6:15 PM

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
Posted by mmasson | 0 Comments
Filed under: ,
 
Page view tracker