must admit I really did prefer the previous search feature, the weighted return was great!!

overall site looks good though, well done!

Well I have finally gotten to the next step.

Using EXPRESSIONS I can dynamically set which of the chosen connection managers I want to use, however I cannot get it to...

Ok, I am starting to understand now.

From the example that I gave, what SSIS tasks do I use to fetch data from the connection1 and insert into connection2?

Just a straight...

Sorry, but I have to be missing something now...

I have an SSIS package that takes a load of data from server1.db_1 (conneciton1) and then inserts that data (after manipulation) into server2.db_2...

can you post your config file?

<?xml version="1.0" encoding="utf-8"?>

<DTSConfiguration>

  <Configuration ConfiguredType="Property" Path="\Package.Variables[User::tSourceConnection].Properties[Value]" ValueType="String">

    <ConfiguredValue>Data Source=dev001server040;Initial Catalog=db_iris;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;</ConfiguredValue>

  </Configuration>

</DTSConfiguration>

Is this config file correct?

<DTSConfiguration>

 <Configuration>

 ConfiguredType="Property" Path="\Package.Variables[User::tSourceConnection].Properties[Value]" ValueType="String"

    <ConfiguredValue>

  Data Source=dev001server040;Initial Catalog=db_iris;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;

  </ConfiguredValue>

 </Configuration>

</DTSConfiguration>

All I am trying to do, is have the source and destination set by an external file....

I am seriously struggling with this... has someone got an example that they could email me?

I am trying to do the same, but struggling, especially since my servers range between 2000 and 2005 SQL.

Great!

I will have a look at that.

Only just recently started SSIS, but does look a lot more powerful!

Sorry I am a numpty when it comes to XML, what do the config files look like?

Sounds to be a good solution, and is what I want, and should...

Now that sounds quite interesting... How does the config database work? Can you setup connection strings for it? Something like this?

TYPE      DEV1  DEV2  DEV3  ....

SourceA  X       Y       Z

.....

Something along those lines??

thanks for that.

I am going to try and stay away from cross database ownership chaining, will try...

some good points.

I particularly like the bit about master, msdb, etc

I am not seeing a major issue, just in the past,...

well, if I take out the insert, and just return top 10, takes a minute 30. if I return top 100 after 12 minutes its only at record 49.

what...