1.

Explain the importance of config files in SSIS.

Answer»

The config file is used for providing inputs to the connection MANAGER about the properties used by the packages and tasks at the run-time. This is especially useful when the changes are deployed on multiple locations or servers as we do not have to worry every time package runs about configuration. Depending on the server or location, the config files are automatically picked and used.
We can store config properties in multiple ways. Some of them are:

  • XML configuration file: Data can be stored as an XML file.
  • Environment VARIABLES: The config data can be stores as part of environment variables.
  • Registry ENTRY: The config can be stored in the registry.
  • Parent package variable: The config can be stored as a variable in a package of a task.
  • SQL Server: The config can be stored in a database table on the SQL Server.


Discussion

No Comment Found

Related InterviewSolutions