Microsoft SQL Server (MS SQL) is a widely used relational database management system. Before attempting to establish a connection with MS SQL, it is important to ensure that the server you are connecting from has the appropriate network access to reach the MS SQL database. This may require configuring your firewall or network settings, depending on your specific setup. 

Once you have confirmed that the necessary access has been granted, you can proceed with providing the relevant information to establish the MS SQL connection. This will typically include details such as the database name, host address, and port number. By completing this process accurately and comprehensively, you can establish a successful connection with MS SQL and begin working with your data. 

The table below provides an explanation and type of parameters that must be filled by the user to establish a connection with MSSQL. It outlines the specific parameters required and their corresponding data types, which must be correctly entered to successfully establish a connection with MSSQL. 

Once the connection with the Microsoft SQL Server (MSSQL) source has been established successfully, the "input" page is utilized to define the data or dataset. This step involves specifying the necessary details related to the data or dataset, such as its location, type, and structure. Ensuring that all the relevant information is accurately entered on the "input" page to properly define the data or dataset is crucial for the successful transfer of data to an MSSQL table. 

A detailed explanation of the Object Explorer feature can be found in section 2.1 of this user manual. This feature enables tables and columns within your database to be easily navigated and selected, and then used in your SQL queries by dragging and dropping them into the input query section. 

To view the results of the written query, refer to section 2.2, which covers the 'Execute Query' feature. This feature allows the user to execute the query and view the output in the result window, as described in the previous section. By combining the Object Explorer feature with the ability to execute SQL queries, users can easily navigate their databases and select tables and columns to be used in their queries. 

To transfer the data package created by the user to a MSSQL table, it is necessary to define an output. If the table is not already present in the database or the user wishes to make modifications like adding columns to it, then they must choose the "Create/Modify Table" option. This allows the user to create a new table or modify an existing one, by specifying the required details such as the table name, data type and size of the columns, and any constraints on the table. It is important to ensure that all the required information is accurately entered when creating or modifying a table in MSSQL.