For monitoring I do recomend SQL Monitor - using it for years and can't go without it.

It has a fully functional 14 days evaluation which may be...

If you get the explain plans for both executions (even just the estimated will suffice) you will most likely see the reason for it.

If I get this right...

Check the the linked server properties and ensure they are the same on both servers.
And I am assuming you are using the oledb provider, not the ODBC one, on...

What are the times for each one of the steps
1 - teradata to staging
2 - staging to final db
3 - final db to tabular (load data)
4...

Most likely the merge is doing data movement.

I recall a document that highlighted that issue very well but could not find it - but as a general rule...

Hum.

Have you looked at the query timeout property of the linked server itself? if this one is set it will be used instead of the global setting.
select...

From my own experience on doing these type of changes my advise is to create another table with the desired datatypes and then do batch inserts from the source table...

A registry change is required to prevent those.
Look at https://docs.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services

By default, in a new installation, Integration Services is configured not to log events that are related...

Just adding a bit here.

In order to execute a package synchronously from dtexec it is necessary to supply a $server configuration parameter
On this case this is supplied...

Do read the following http://bidn.com/Blogs/Performance-Tuning-of-Tabular-Models-in-SSAS-2012-Whitepaper-Now-Available and the white paper mentioned on it.

Partitions are good for incremental loading - or if your server and tabular instances are correctly configured,...

"The bottle neck appears to be the loading of the tables."

Normally when this happens after awhile its most common reason is that originally the table was "small" and...

depending on how stable your data is the following approach may result in very little down time comparing to a full copy back at a point in time.

It...

it has to do with your server/session collation.
I'm not even sure which collation the link you supplied is.

In order to determine the values for your current collation...

Without having access to the views and underlying tables/index its impossible to give a good answer.
not knowing the data also doesn't help.

You will need to get your...

Straight combination of sql server agent job with 2 steps
step 1 - execute command file - issue the ftp command to get the file onto a local folder and...