Post reply

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

  • July 30, 2008 at 12:23 am

    #210602

    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]

  • July 30, 2008 at 6:00 am

    #850397

    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.

  • July 30, 2008 at 6:30 am

    #850417

    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 .

    Thanks,

    Ira

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

  • March 3, 2009 at 4:31 am

    #952316

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

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

  • April 21, 2009 at 11:19 am

    #981647

    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()

  • May 20, 2009 at 1:13 pm

    #997847

    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 ?

    Thanks.

  • May 21, 2009 at 9:46 am

    #998364

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

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

  • May 21, 2009 at 11:19 am

    #998420

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

    Thank you Mr. Whiteside. 😀

  • March 11, 2010 at 3:43 pm

    #1132371

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

  • March 18, 2010 at 1:38 pm

    #1136264

    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]

  • October 21, 2010 at 8:23 pm

    #1240683

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

  • June 21, 2012 at 7:09 am

    #1503909

    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.

  • December 13, 2012 at 6:23 am

    #1568279

    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