Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2008 12:23 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:31 AM
Points: 42, Visits: 289
Comments posted to this topic are about the item Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component

Ira Warren Whiteside
Post #543199
Posted Wednesday, July 30, 2008 6:00 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:26 AM
Points: 251, Visits: 364
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.


Post #543365
Posted Wednesday, July 30, 2008 6:30 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:31 AM
Points: 42, Visits: 289
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


Ira Warren Whiteside
Post #543386
Posted Tuesday, March 03, 2009 4:31 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:31 AM
Points: 42, Visits: 289
The code for our SQL Server Central Articles on Extending SSIS is now available here.




Ira Warren Whiteside
Post #667165
Posted Tuesday, April 21, 2009 11:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 2:37 AM
Points: 2, Visits: 53
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()
Post #701702
Posted Wednesday, May 20, 2009 1:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 3:51 PM
Points: 9, Visits: 64
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.
Post #720846
Posted Thursday, May 21, 2009 9:46 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:31 AM
Points: 42, Visits: 289
Have you tried copying the dll from Pipeline components to the GAC(Windows\Assembly)

Ira Warren Whiteside
Post #721461
Posted Thursday, May 21, 2009 11:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 3:51 PM
Points: 9, Visits: 64
Yes, it worked after I copied the findvendparseaddr.DLL to the GAC.

Thank you Mr. Whiteside.
Post #721526
Posted Thursday, March 11, 2010 3:43 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 20, 2013 2:52 PM
Points: 1, Visits: 58
Trying to download your source code but keep getting a server unavailable. It the link still active? Thanks!
Post #881397
Posted Thursday, March 18, 2010 1:38 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:31 AM
Points: 42, Visits: 289
Sorry, went down. Send me your email to iwhiteside@iwhiteside.com, I will forward, I also have a 2008 version now.

Ira Warren Whiteside
Post #885865
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse