blogs.conchango.com

welcome to the conchango blogging site
Welcome to blogs.conchango.com Sign in | Join | Help
in Search

SSIS Junkie

Conchango are busy and need talented consultants in and around London. Interested? Email me or send me a message

SSIS: Normaliser Component bug fix

17 days ago I released my Normaliser Component but embarrassingly it turns out there was a small bug. Any null values in the sorted columns on the component input would cause the component to throw a nasty unhandled error.

I've fixed the bug in v1.1 which you can get from here:

You will need to uninstall the previous version (via Control Panel) and also remove it from the Visual Studio toolbox. Then follow the install procedure using the new version as detailed before. Any packages that use the previous version of the component will need to be edited so that the previous version is removed and this new version added.

Apologies for any inconvenience caused.

By the way, if you want to see which version happens to be in a machine then browse to the GAC (c:\windows\assembly) and check the properties of Jamiet.Ssis.NormaliserComponent. If it looks like the following then you're good to go.

-Jamie

Published 25 September 2007 05:44 by jamie.thomson

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

SSIS Junkie : SSIS: The Normaliser Component said:

September 25, 2007 05:54
 

Darren Green said:

Using one of the alternative version attributes might have been nice rather than the assembly version, such as AssemblyFileVersion. Saves having to rebuild the task or hacking the XML to cater for the strong name change.

September 25, 2007 12:34
 

Jason Haley said:

September 25, 2007 15:21
 

Alex Crockett said:

jamie

I've used the normaliser in many different environments but I've encountered a weird installation issue today and wondered if you had any advice.  It appears to install OK, its present in windows\assembly and the correct version has been installed.  However when i try to add it to my Toolbox it doesnt appear in the list of available transforms? have you experienced this problem, and if so can you provide a solution please?

Cheers

Alex.

March 13, 2008 13:41
 

jamie.thomson said:

Hi Alex,

Hmmm...weird. Does the assembly appear in %programfiles%\Microsoft SQL Server\Dts\PipelineComponents?

-Jamie

March 13, 2008 13:46
 

Alex Crockett said:

Jamie,

Please ignore my last message......  I was behind 2 VM's and a couple of RDC's and lost sight of where I was!!!!  Ahhhhhhggggg

Cheers

Al.

March 13, 2008 13:47
 

jamie.thomson said:

Phew!

:)

March 13, 2008 13:54

Leave a Comment

(required) 
(optional)
(required) 
Submit

This Blog

Syndication

News

Powered by Community Server (Personal Edition), by Telligent Systems