473,749 Members | 2,451 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.LoadFr om("D:\\Develop ment\\TestApp\\ Utils\\bin
\\Debug\\Utils. dll")
tObject = LILI_UTILS.GetT ype("Utils.Data .TheObject")
TheObject = tObject .InvokeMember(" TheObject",
BindingFlags.Cr eateInstance, Nothing, Nothing, Nothing)
TheObject.Valid ate(SomeData)

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\b inn\" rather than it's
specific config file. This is backed by the fact that examining the
AppDomain.Curre ntDomain object shows that the BaseDirectory is "C:
\Program Files\Microsoft SQL Server\90\DTS\b inn\".

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\b inn\"? 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.

thanks

Hoots.

Jun 27 '07 #1
0 1221

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

Similar topics

0
5307
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 parameters (6) are fine. I've tried casting and still have no luck. The error is SQL0440N. I am running with DB2 Client 8.2.4. The sql call in BIDS looks like... call ODW.ODWCY002 ('TN',cast '43','04/20/2006',0,' ',' ') the linkage section in the cobol sp looks like... 01 LK01-ODW-ST-CD...
0
1835
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 Folder I have defined mappings for 17 dimensions. 1st Dimension say Account has been Set up as a startup object. Now when I run the package ir runs only my account dimension and loads the target,other dimensions are not run at all!
1
9312
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 appear in a folder. The tables are/can be all different fields, field widths, etc. With quite a bit of overlap though. The end result should be table "ABC.DBF" is pulled into SQL Server as
2
8842
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 output i want is a DBF table "abc.dbf" .this should be done using SSIS.
1
1912
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 something..... I want to design a SSIS script that will pull XML data from a secure HTTP website direct in to a local database table. I have had no training on SQL Server 2005 SSIS. I have a reasonable
9
10504
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 "For each loop" container in a ssis package like this: Truncate table <tableName> Insert into <tableName> Exec (' select from '+ ?) It gives me error message when I try run the ssis. However if I put the above statements into a stored procedure and wrote look this, it
6
6103
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 from a Double Byte Progress database and the "DataReader Source" using a ADO .NET ODBC provider does not work! I understand that SSIS is a totally rewritten version of DTS. What annoys me is that this functionality used to work in DTS and does not in the much talked about SSIS!! Will someone in...
3
4634
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 Server tables with many derived columns and transformations in between. It seems to automatically map columns from the flat file to columns in the sql table where the names of the columns are equal. But can it also do it automatically on position, so flat file column 1 goes to sql table colum 1,...
2
3797
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 convert things to Script tasks (in VB .net). I have a script that is zipping up some files, and it's using an old Winzip, which I don't have on my pc, and certainly wouldn't have on the server, once I got the code over there. So, I wanted to use the built-in zip function for XP. If, in Windows...
0
8833
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9568
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9335
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8257
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6801
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4881
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3320
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2794
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2218
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.