posted on Wednesday, September 21, 2005 8:43 AM by SimonSabin

My SSIS Custom components

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/My SSIS Custom components
The new RSS feed is here

The following are the custom components I am working on

Sources

  • SQL profiler log file Source
    • Reads SQL Profiler files
  • Log parser source (In progress)
    • Reads IIS log files and copes with restarts that repeat the column names in the files

Transforms

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/My SSIS Custom components

Comments

# re: My SSIS Custom components @ Wednesday, December 07, 2005 9:43 PM

Hi Simon,

I was scanning through your blog and couldn't help myself to really appreciate your wish list for SSIS. Regarding your SSIS Custom Components, I was wondering where you were with the "Enhanced Error Transform." I'm currently trying to find an elegant way to associate the proper column name to the ErrorColumn id returned by SSIS error output (and sure wish that all the package info would be available in ComponentMetadata...) and was wondering how you were handling that. Care to share your thoughts?

AL

# re: My SSIS Custom components @ Wednesday, May 31, 2006 1:58 AM

Hi Simon,
I understand that you have lots of knowledge on SSIS by looking in to your blog. Information in your blog is very useful.

By anychance do you work with creating SSIS packages programatically? I'm a new comer to SSIS and trying to learn creating SSIS packages using C#. I've succedded in adding basic tasks and components like Data Flow, Flat file source, OLEDB Destination. But I really dont have any clue on how to do the following

1)set up script to a Script Component.
2)Set up properties of Look up transformation.

Could please you help me by giving sample code?

Gopinath M

# re: My SSIS Custom components @ Wednesday, June 14, 2006 5:54 PM

Hi Simon,

I've been using your Enhanced Error Transform, and it is very useful. Thanks! Would it be possible to provide the source code for that component so that the Error Description can be added as well? Right now, I've got a separate one-line script component in my packages to read and interpret the ErrorCode:

Row.ERRORDESCRIPTION = Me.ComponentMetaData.GetErrorDescription(Row.ErrorCode)

It seems as though this would be an easy addition to your Enhanced Error Transform. If you'd rather not supply the source code, can you publish an upgraded version?

Please let me know,
Thanks
Alex

Alex Levene

# re: My SSIS Custom components @ Wednesday, June 14, 2006 7:04 PM

I am rewriting the code because SP1 has some new features that simplify things.

Will provide an update when I do.

SimonSabin