Care to post the error?

If you don't specify the schema on creation it will create the object in the users default schema.

If the user doesn't have permissions to alter that schema it will fail.

It...

Are the columns the same from each DB?

If so you want union/union all

MSA's are supported on 2003 and 2008 domain controllers aslong as you follow additional setup steps to enable the support.

MSA's are supported on 2008 R2 or above schema domain controllers.

I...

The installation will assign the NT SERVICE group to the folder permissions.

NT SERVICE\MSSQLSERVER if using a default instance or NT SERVICE\MSSQL$INSTANCENAME if using a named instance.

When you change the accounts...

An SSIS package is an XML file, it cannot be converted to T-SQL.

What is the overall goal here?

1 Script to connect to multiple hosts, to download a specific table?

SSIS would...

Please post create view/table scripts along with sample data for the following tables / views

vw_tblBusinessFinancialInformation - and all referenced tables in the view

vw_tblCompany_BusinessFinancialInformation - and all referenced tables in the...

Best practice I always follow is each service has its own service account.

Import/Export is self explanatory, export data from A import it to B

Replication is a bit more complicated, see this link for reading on the topic http://www.sqlservercentral.com/stairway/72401/

Could also check sys.database_permissions and join back to sys.database_principles on the grantor to see which login did it. But if its a group then you will need to check...

Create a new SSRS project in visual studio and add the rdl files in as existing files, then add the project to TFS/Source Control

Guessing the problem is down to using WAITFOR DELAY '00:15' in the query to wait the 15 minutes.

Is a logic change possible to the job?

If so, my recommendation would be...

MSDN details its a 20 minute refresh

https://msdn.microsoft.com/en-gb/library/ms188924(v=sql.105).aspx

It gets updated every 20 minutes.

Hunger