6. Click New Query in SQL Server Management Studio and type select @@servername to verify everything is correct and you have successfully changed the sql server name.

How to Connect to MySQL in SSIS. Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or ...

Default Database (optional): The name of one of your databases found on the MySQL server, which can be listed from the MySQL console with the query SHOW DATABASES;.

You create a data source name (DSN) to save database setup information, so you can open a connection to the SQL Server database without re-entering the server information.