Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component

  • Comments posted to this topic are about the item Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component

    [font="Comic Sans MS"]Ira Warren Whiteside[/font]

  • It would be great to be able to see the pictures that were uploaded. Perhaps my firewall is blocking them, but I don't think so. Seems like some relative links are broken and should've perhaps been coded as absolutes.

  • Thanks for catching this, I have contacted the Webmaster to work to resolve the image issue. You can download a pdf for the artciel via http://actualitybusinessintelligence.com/articles.aspx .



    [font="Comic Sans MS"]Ira Warren Whiteside[/font]

  • The code for our SQL Server Central Articles on Extending SSIS is now available here.

    [font="Comic Sans MS"]Ira Warren Whiteside[/font]

  • I tried to implement the sample code for this, and after attaching the Excel file to the Excel source object, I tried attaching it to the findvendparseaddr custom component. I can specify the five input columns, but the component doesn't display any output columns, and I get the following error message: System.NullReferenceException: Object reference not set to an instance of an object at findparsevendaddr.SampleProject.Validate()

  • Hi Mr Whiteside,

    I have SQL Server 2008 (not 2005) and Microsoft Visual Studio 2008.

    Initially your solution for findvendparseaddr Data flow component would not build but I successfully modified it

    (I changed all the types that ended in 90 to 100, for example IDTSCustomProperty90 was chnaged to IDTSCustomProperty100) and it did compile successfully. I altered the output path of the DLL so that it was created in Program Files\Microsoft SQL Server\100\DTS\PipelineComponents

    But I still could not get the component to show up in the SSIS Data Flow Items tab in Choose Toolbox Items. I verified that the findvendparseaddr.dll was there in the Program Files\Microsoft SQL Server\100\DTS\PipelineComponents directory but the findvendparseaddr would not show even after I Reset the toolbar several times.

    Do you have any ideas ?


  • Have you tried copying the dll from Pipeline components to the GAC(Windows\Assembly)

    [font="Comic Sans MS"]Ira Warren Whiteside[/font]

  • Yes, it worked after I copied the findvendparseaddr.DLL to the GAC.

    Thank you Mr. Whiteside. 😀

  • Trying to download your source code but keep getting a server unavailable. It the link still active? Thanks!

  • Sorry, went down. Send me your email to iwhiteside@iwhiteside.com, I will forward, I also have a 2008 version now.

    [font="Comic Sans MS"]Ira Warren Whiteside[/font]

  • can you please send me the code at friendny@yahoo.com....thanks

  • Hi,

    I am trying to download the source code and sample but getting not found message. Please can you get the sample code and the files.

  • Hi Ira, i sent you a mail on December 3

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply