The Options dialog allows you to configure database and package settings for SQL Data Sets. You can open the Options dialog by selecting File > Options from the main menu.


Database options

Connection timeout The connection timeout is the time in seconds that SQL Data Sets will wait to connect to a database. If the connection takes longer than the provided value, SQL Data Sets aborts the connection. The default value is 15 seconds. Command timeout The command timeout is the time in seconds that SQL Data Sets will wait for a SQL command to complete. If the command takes longer than the entered value to complete, SQL Data Sets aborts the command. The default value is 300 seconds, which means that SQL Data Sets will wait up to 5 minutes for the SQL command to complete.

Package options

Compression level SQL Data Sets compresses the data sets in a package to create a smaller file. You can control the amount of compression that's applied to the data sets. A higher compression level usually results in a smaller file, but takes longer to create. The default compression level is 'Normal', which strikes a balance between compression level and speed.