Test script for SSDT

DSSH 61 Reputation points
2021-03-03T22:58:38.467+00:00

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
    2021-03-04T03:32:43.197+00:00

    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,
    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.


1 additional answer

Sort by: Most helpful
  1. DSSH 61 Reputation points
    2021-03-04T15:52:45.647+00:00

    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