I am trying to use LLBLGEN to write a loader where I will be reading from one database, transforming data and writing to another (SqlServer to Access or Access to Access).

Could someone tell me the best way to use LLBLGen to allow me to read from one db and write to another? I am comfortable with getting access to the entities that i need to transform the data, but I'm having problems accessing the other db due to the fact that my app wants to use the connection string of the first db.

DTS isnt really the solution for me here as I will run this data through a number of transformations and calculations before I write to the other database. (I only have read-access to the database where I am getting the data).

Any advise would be greatly appreciated. I am using the self-servicing approach.

You should have 2 LLBLGen projects each targeting one database, and in turn they will generate 2 SelfServicing assemblies that you should use.

The query string can be programatically passed to each one of them as follows:

DbUtils.ActualConnectionString = "Datasource=myserver;....";