An update, when I pick MultiServer in the dropdown of servers in Oledb Source within the data flow task, which is within the for each loop.

I get the following msg

Error at Data Flow Task [OLE DB Source [1]]: The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0202009.

Error at DbCapacity [Connection manager "MultiServer"]: An OLE DB error has occurred. Error code: 0x80040E4D.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Login failed for user 'user'.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E4D Description: "Invalid connection string attribute".