ScottPletcher (2/9/2016)
That sounds like Oracle not SQL Server. SS doesn't have CTAS syntax.
It's SQL Server Parallel Data Warehouse aka APS, or the Azure version of it, Azure DWH. CTAS replaces SELECT ... INTO in the PDW.
PDW is not a standard SQL Server, SSIS is not a good option for working on data within the PDW, because it doesn't take advantage of the distributed nature of the data, and it requires pulling the data out and putting it back in.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability