Deployment of custom assembly referenced in script components.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

My SSIS solution includes a custom .Net assembly that I reference from
script components within my packages. I deploy multiple instances of the
solution to a single server (SQL Server cluster) and would find the
flexibility of being able to deploy new versions of the assembly on an
instance by instance basis really valuable.

The current deployment process involves copying the assembly to the
following directories on both nodes of the SQL Server cluster.

C:\Program Files\Microsoft SQL Server\90\DTS\Binn
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

At which point, they are visible to all instances of my solution.

My ideal solution would be to have each instance reference the copy of the
assembly that is located within the same folder as the packages (these are
deployed on the file system).

I found a reference on the net to the 'ReferencePath' attribute within the
dstx file and experimented (appended the package path to the value of this
attribute) without success. Has anyone managed to get this working?

Are there any other strategies that I should be considering?

Many thanks,

Scott
.

Relevant Pages

  • Is there a tool to make a runtime package containing all referenced units?
    ... I'm thinking of migrating to a plugin system but I am concerned about the need to ship packages. ... If I move to a plugin system then either both the plugins and the main app will have units linked in so and these may be duplicated. ... Also in some cases there is the problem of conflicts when both reference a unit that used Classes.RegisterClass -- the remobjects people a faq about this. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: problem with Bibtex
    ... instead of my reference in the text. ... My apologies for the too long list of packages, ... only in the output of the last latex run are the references resolved. ... note that debuggers seldom need to know the enormous list of packages ...
    (comp.text.tex)
  • Re: World book software?
    ... have downloaded two packages - HelpExpert ... want it to automatically recognize terms that have entries and hot ... For bonus points the main entry should ... have a list of links that go to other entries that reference the ...
    (rec.games.frp.misc)
  • hyperref and algorithm incompatibility
    ... I've just found an incompatibility between the hyperref and algorithm ... packages when trying to make a reference to an algorithm. ... Does anyone if there is some proper way to load these two packages ... Is the fix that I found reasonable, or I may enconter some more ...
    (comp.text.tex)