Script Task is one way.

another way is using variable to store the list of ID, then access server B based on the variable. So you don't have to access both...

Recommand using SQL Server Profiler + Performance Monitor to catch the sessions.

for example, convert string '$123456789' to money 1234567.89

1. Use Data Coversion to convert '$123456789' to data type currency[DT_CY], it will be 123456789 in a new output alia after this...

if you want to do data conversion, like convert string to money, I suggest to use 'Data Conversion' instead of 'Derived Column', it's easier.