SQL Server

SQL Server Integration Services (SSIS)


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.
Syndicate content