question

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

Test script for SSDT

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

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.



· 2 ·
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.

Thank you Monalv-msft, yes we have ssis packages, want to know how can I check the connectivity between the database and package.

0 Votes 0 ·

Hi @DSSH-8859 ,

May I know if you create connection manager?

74165-connectionmanager.png

74185-testconnection.png

Best regards,
Mona

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

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?

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