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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ira Whiteside » Extending SSIS Part 1 - Creating a Custom...

13 posts, Page 1 of 2

1 2 »»

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

Rate Topic

Display Mode

Topic Options

Author

Message

Ira Warren Whiteside

Posted Wednesday, July 30, 2008 12:23 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

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

jdshabat

Posted Wednesday, July 30, 2008 6:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 12:46 PM
Points: 193, Visits: 327

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

Ira Warren Whiteside

Posted Wednesday, July 30, 2008 6:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

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

Ira Warren Whiteside

Posted Tuesday, March 03, 2009 4:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

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

Ira Warren Whiteside

Post #667165

Robert Dickey

Posted Tuesday, April 21, 2009 11:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, February 24, 2013 12:15 AM
Points: 2, Visits: 52

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

vivekmang

Posted Wednesday, May 20, 2009 1:13 PM

Forum 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

Ira Warren Whiteside

Posted Thursday, May 21, 2009 9:46 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

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

Ira Warren Whiteside

Post #721461

vivekmang

Posted Thursday, May 21, 2009 11:19 AM

Forum 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. BigGrin

Post #721526

smorgan-697807

Posted Thursday, March 11, 2010 3:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 13, 2013 3:15 PM
Points: 1, Visits: 57

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

Post #881397

Ira Warren Whiteside

Posted Thursday, March 18, 2010 1:38 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:48 PM
Points: 42, Visits: 272

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 »

13 posts, Page 1 of 2

1 2 »»

Permissions