I am trying to do a select from ServerA (which is a variable populated by a select statement) - and update a table with the result of the select into server B with a where clause
What is the best way to achieve this?
Normally a simple data flow task would suffice but as i am using xp_instance_regread in my select to get the PORTNumber of the instance, it errors.
I am guessing I will need an Execute SQL task for selecting the port number, put this into a variable, then data flow task to input the variable into a table but im not sure how to achieve the mapping?