We want to test PSSA on 2016. PSSA was working fine in 2012 infrastructure.
We upgrade SSIS package file Mainpackage using SSDT 2015 and started the job. We received error:
The connection “Higher Ed Analytics Data Warehouse – Managed” is not found.
This error is thrown by Connections collection when the specific connection element is not found.
On investigation we opened DetailSubPackage in SSDT 2015 and found it to be non empty.
We copied DetailSubPackage from our working 2012 server. Viola! the pSSA job started working.
select top 1000 * from Hea.EventLog
order by EventTimeStamp desc
The above query started showing the logs.