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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy