Wednesday, March 7, 2012

Creating a Data-Flow Component

I try to create a new Data-Flow Component.

In Books-Online I found this link:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.de/dtsref9/html/9d96bcf5-eba8-44bd-b113-ed51ad0d0521.htm

and the following pages.

But I have not realized, how I have to create the new Data-Flow Component.

What I to do for my first "Hello World"-Component?
SQL Server also includes 4 code samples of working data flow components, one each of the 4 types that can be created. This is a good place to start.

-Doug|||

I have found the example and have installed the "ADO Source"-Component.
The installation is a little bit more difficult, than I thought.

But it is a good example to start.

Thanks - Loom

|||Since you will be using the same series of steps to deploy and test your own data flow components, best to resign oneself!

Note that Visual Studio 2005 supports post-build event scripts that you can use to copy your updated assembly to the PipelineComponents folder, remove the previous version from the global assembly cache, and install the latest version.

Before you get started, read the docs too to make sure that you can't do what you want to do with the Script Component...it will save you a massive amount of time and coding overhead!

-Doug

No comments:

Post a Comment