Delete the existing DetailSubPackage and copy the correct one from other server or from BlackBoard

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s