with linked server you can join all 3 sources - but DO NOT DO IT!!!

As you read it and mentioned on your post it will copy the data from the...

I decided to try to push some buttons on this, and sent an email to the relevant European commissioner, saying The latest "upgrade" of the Microsoft  Winows 10...

In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far into...

following article from Solomon Rutzky probably what you looking for https://sqlquantumleap.com/2018/02/15/safely-and-easily-use-high-level-permissions-without-granting-them-to-anyone-server-level/

His CLR related posts are really a must read for anyone that needs to allow users to use "higher privilege"...

Although it is one of those things that experienced people would frown upon, its purpose is to ensure that the one being interviewed knows how to deal with conditional flows...

Thom - VS 2017 now has a Data tools options as part of its install  but unfortunately MS messed it up and the default SSDT VS 2017 setup only installs...

from the documentation

Install Analysis Services, Integration Services, and Reporting Services tools

To install AS, IS, and RS project support, run the SSDT standalone installer.

https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017#ssdt-for-vs-2017-standalone-installer

you need to install the correct components from Oracle client - if your workstation is 64 bit you need both 64 and 32 bit Oracle client.

when installing (Custom installation) you...

your company should contact Microsoft and/or one of their vendors and ask for that info.

Regarding SQL server yes they do need to pay for it - MSDN SQL Server can't...

cross post from another forum https://www.tek-tips.com/viewthread.cfm?qid=1794041 - reply posted there.

How about people that just implement missing index recommendations that create a nonclustered index that is a covering index and recreates the entire table?  Yes, I found one...

Ranting: Just noticed that you said your company recently upgrated to SQL 2012 - WHY!! at this point in time they should have gone to 2016 or 2017.

A bit of...

your idea of copying to SQL will work and in some cases could be the best option.

Is the table in Oracle updated outside this SSIS process? If not then you...

memory available is normally based on number of processors, not cores as far as I know.

and depending on the processor model memory on this model can be higher than the...

also

Site slow when going through the latest topics, both initial page and next pages.

Layout / colour schema quite annoying. Lost one post already because of the fact that existing /...