We migrated over from old sql server 2008 to a new one that is 2012. When running a process in SSDT we see “Not Responding” when running a process which is not normal behavior on the old server or when running SSIS or SSDT locally.
When it actually runs it is not showing the typical “hour glass” or donut icon we would see on the container to show that’s it running. It told me the solution/package was running, but nothing actually happened and no data was loaded. It’s a basic import script, nothing is being imported into table from new environment. Any thoughts on how to troubleshoot.
NEW SQL SERVER IS 2012 , OLD SQL SERVER WAS 2008