How many Configuration types available in SSIS? SSIS Interview Questions

Questions: How many Configuration types available in SSIS?
Ans: There are 5 configuration types available in SSIS

  • XML configuration file
  • Environment variable
  • Registry entry
  • Parent package variable
  • SQL Server


Comments

  1. Control stream component is one that plays out any capacity or gives structure or control the stream of the components. There must be no less than one control stream component in the SSIS bundle. In SSIS a work process is known as a control-stream. A control-stream interfaces together our secluded information streams as a progression of operations with a specific end goal to accomplish a coveted result.

    ReplyDelete

Archive

Contact Form

Send