SQL Server Integration Services (SSIS)

Questions

These questions are things I'm still researching.

  • Q: How does a sequence container work?
  • Q: What is special about Business Intelligence Development Studio?
  • Q: How do "file packages" get created/deployed/executed/scheduled?
  • Q: How can packages be configured for environment-specific settings that get evaluated at runtime?
    • A: Configurations files are created through the Package Configuration Wizard in Visual Studio. These files can be used via a command-line parameter for the DTEXEC.EXE command.