Test script for SSDT

DSSH 61 Reputation points

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,485 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,896 Reputation points

    Hi @DSSH ,

    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,


    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.

1 additional answer

Sort by: Most helpful
  1. DSSH 61 Reputation points

    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?

    0 comments No comments