dbTalk Databases Forums  

Custom task dependencies (SQL 2005 IS)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Custom task dependencies (SQL 2005 IS) in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Albert
 
Posts: n/a

Default Custom task dependencies (SQL 2005 IS) - 12-02-2005 , 04:45 PM






I built a custom component (con. mgr.) that uses some external dependencies
(dlls) and properly registered it with SSIS. When I open up BI studio, create
an IS project and bring up the Package designer (and do all the other
required stuff to make it actually visible in the Toolbox) I can see my
connection manager add click to add it to the package. However, the process
fails at this point due to unresolved file locations. When I looked at the
error closer it showed me that devenv.exe does the search for the assembly
only within its own application scope (.config, machine.config, probing etc)
but wouldn't bother looking under the dlls folders.

What are my options?

Thanks

Vito

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Custom task dependencies (SQL 2005 IS) - 12-05-2005 , 10:03 AM






Install your additional assemblies in the GAC? Works for me, for some shared
resources I have bween several tasks/connectiosn etc.

"Albert" <Albert (AT) discussions (DOT) microsoft.com> wrote

Quote:
I built a custom component (con. mgr.) that uses some external dependencies
(dlls) and properly registered it with SSIS. When I open up BI studio,
create
an IS project and bring up the Package designer (and do all the other
required stuff to make it actually visible in the Toolbox) I can see my
connection manager add click to add it to the package. However, the
process
fails at this point due to unresolved file locations. When I looked at the
error closer it showed me that devenv.exe does the search for the assembly
only within its own application scope (.config, machine.config, probing
etc)
but wouldn't bother looking under the dlls folders.

What are my options?

Thanks

Vito



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.