This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 63%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hi @DSSH ,
May I know if you run ssis package in SSDT?
Could you please share more error information?
Best regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Yes, run in SSDT. It does not give an error, when finally completes and check the table, nothing in table. Worked fine in old environment, not working in new .
Any suggestions on test I can run to see what maybe my issue?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @DSSH ,
Are you using Integration Services Catalog and SSISDB database?
You need to turn on verbose logging, and run the built-in SSIS reports in SSMS.
It will reveal what is going on.
Hi @DSSH ,
1.If we execute SSIS Package inside SSDT for Visual Studio, please click Debug > Windows > Output.
2.If the packages ran from SSMS under SSIS Catalog, please right click on Package > Reports > Standard Reports > All executions.
3.If the execute the packages not stored in SSIS Catalog in SQL Agent Job, please right click on the job and choose View History.
Please refer to How to view SSIS Package execution log in Visual Studio / SSIS Catalog Execution / Job Log.
Best regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.