Is there a way or a test script that can be run to check if have any issues between SQL tools and a database? Having connectivity issues with the tool and database
Is there a way or a test script that can be run to check if have any issues between SQL tools and a database? Having connectivity issues with the tool and database
Hi @DSSH-8859 ,
May I know if you create ssis package and connection managers in SSDT?
Please refer to Integration Services (SSIS) Packages and Integration Services (SSIS) Connections.
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.
Thank you Monalv-msft, yes we have ssis packages, want to know how can I check the connectivity between the database and package.
Thank you , yes have connection manager. I am thinking the issue maybe with the database, is there a way to check the health of a database?
4 people are following this question.
SSIS Scale Out and its services on local group policies
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
we hope Microsoft can develop databases like mysql
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
SSIS - getting data from Oracle - not working preview and metadata refresh