We are on SQL server 2014. This past Friday we migrated a database from one datacenter to another. Many weeks prior we had setup the database and along with that came a few jobs with SSIS packages which basically read in text files and load to the pertaining tables depending on the input file. Prior to the migration I had tested the SSIS packages many times with no issue. Friday night for the final switchover we needed to refresh the DB from the current DB in the other datacenter. As a final test before the refresh I ran the SSIS one last time and all was fine. I am not a DBA but next steps were performed by the DBAs to create files from the existing DB and then copy them to the new server (however that is done). The process took some time due to a slow network so this took us into Saturday. during this time nothing was done on the new DB just waiting for the DBA to copy over the data and refresh the database. I did not realize but the job was enabled so it ran at its scheduled time early in the morning. so this issue really occurred before the DBAs even started on the refresh, the files were still copying over. I noticed the process was running, the first step copies the input files and had ran to completion and it was just sitting there in the SSIS step no log information or anything. We cancelled and tried many times with the same issue. When you look at the job activity monitor you can see that it is sitting in that step in the status column. but when you go to the job and select the view job history usually you can see the process even while it is still running but there is no indication of the job at all. So it is like something in the very very beginning is keeping it from proceeding. We went ahead with the refresh and the issue continues. Sorry for the book but I wanted you to have all the details.