question

DSSH-8859 avatar image
0 Votes"
DSSH-8859 asked ·

SSIS/SSDT process not responding on new sql server

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

sql-server-reporting-servicessql-server-integration-servicessql-server-analysis-services
· 3
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @DSSH-8859 ,

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.


0 Votes 0 ·

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 .

0 Votes 0 ·

Any suggestions on test I can run to see what maybe my issue?

0 Votes 0 ·
YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered ·

Hi @DSSH-8859,

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.

75885-ssisdb-catalog.png



ssisdb-catalog.png (85.3 KiB)
·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered ·

Hi @DSSH-8859 ,

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.



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.