472,353 Members | 1,238 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Config files problem and SSIS

The Problem:

I want to be able to use an assembly of an independant application
which is not strong named from within an SSIS script component. I have
created a wrapper assembly (Utils.dll) which is located in the same
directory as it's dependant Dlls for this purpose and I'm calling it
using reflection, example script code is:

Dim UTILS as Assembly
Dim tObject As Type
Dim TheObject as Object

UTILS = Assembly.LoadFrom("D:\\Development\\TestApp\\Utils \\bin
tObject = LILI_UTILS.GetType("Utils.Data.TheObject")
TheObject = tObject .InvokeMember("TheObject",
BindingFlags.CreateInstance, Nothing, Nothing, Nothing)

Although I can call the Validate method, the Validate method uses an
object in this external application assembly, but that object is
reporting that it can't find a certain entry in the config file which
I assume is because it's looking at one of the config files in "C:
\Program Files\Microsoft SQL Server\90\DTS\binn\" rather than it's
specific config file. This is backed by the fact that examining the
AppDomain.CurrentDomain object shows that the BaseDirectory is "C:
\Program Files\Microsoft SQL Server\90\DTS\binn\".

Now I don't know the ins and outs of this external application and I
don't have control of it, in fact it has about 50 of it's own config
files so I don't want to mess about with config structures. Is it
possible to make the working folder for SSIS different to "C:\Program
Files\Microsoft SQL Server\90\DTS\binn\"? Would this even work or is
there another way of making the correct config information being
picked up?

If anyone has any ideas it would be much appreciated, I really could
do with finding a way to use aspects of this external system without
knowing everything about it, there are so many dlls and configurations
of this external app that I just don't know about.



Jun 27 '07 #1
0 1108

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: stant | last post by:
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of...
by: AMAN | last post by:
Hi all, I am a newbie to SSIS.Need a solution to couple of issues I am currently facing while developing ETL in SSIS 1) Under SSIS Package...
by: SQLNewbie | last post by:
Hi all, New to SQL Server - trying to create an SSIS package that will look for and import a series of Visual Foxpro tables (.DBFs) when they...
by: sreekanth123 | last post by:
Hi, I want to use data from a sql database and convert it to DBF files using SSIS. i.e., Want to extract data from a sql table say "abc" and...
by: rmsterling | last post by:
All, Subject : SQL Server 2005 SSIS Script Help - XML Secure Pull in to DB table I was wondering if any of you could help me with...
by: gelangov | last post by:
I have 2 variables, one is the column name of the table and the other one is the table name and I need to write this in the "Execute SQL task" of a...
by: jags_32 | last post by:
We have spent days trying to perform a proof of concept and I am dissappointed with SSIS to say the least. We are trying to connect and fetch data...
by: stephen | last post by:
I had to use use ssis 2005 in a short project recently & had little time to work it out. I was importing a whole bunch of flat files into SQL...
by: karen.google | last post by:
I have an SSIS package that I'm converting from DTS (SQLServer 2005), and the ActiveX Script Task (in VBScript) is deprecated, so I'm trying to...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.