SSIS can be a bit tricky. Visual Studio is 32 bit only, so if you do any testing or development on the server itself, you will be doing so...

You would have to enclose it in square brackets:

[My.Schema].[MyTable]

I would say that putting a dot in your schema name is a really bad idea.

I am assuming this is a 32 bit server.

Enabling AWE at the OS and SQL Server level is probably what you will want to do for now. Depending on...

I have yet to find an Oracle driver that is actually 100% OLEDB compliant. Both the MS and the Oracle native client have trouble with numeric data types. ...

When it is "stuck", what state is the update in? Check it with sp_who2.

Most stuck processes are either blocked by another process or SUSPENDED waiting on a resource. ...

You have left some information out, so here are a few questions.

What does the database design look like? 15tb is a lot different if there is one very large...

"Dirty Reads" is also a bit misleading. It is possible to miss data and read the same data more than once.

For example, if you query a list of people...

Don't join an INT to a NUMERIC in a lookup. They may not always match - especially if you are using an Oracle or Sybase data source. Use...

RTRIM() or TRIM() everything. Trailing spaces get in the way a lot.

If the lookup is telling you that it found no matches, trust it. It found no matches.

By looking at your DDL, I would guess that you have a VARCHAR...

There is some limit. I don't think it is the number of nested functions, I think it is the length of the text of the expression. It's pretty...

You need to get some SSIS training. It is very different from SSIS. Pick up a book ASAP.

This should be done using a derived column transformation.

If you are getting the error where I think you are in the process, the path needs to be UNC to a shared folder path. Your subscriber is looking...

As far as security, to use SSIS for this, I would recommend a VPN tunnel. If you cannot do that, to connect to your ISP's SQL Server directly from...

AS previously posted, there are not a lot of down sides. You need enterprise SQL, so make sure you have ponied up for the licensing. The possible performance...