dataflow.xml

<# foreach (var worksheet in worksheetCollection) {#>
  <Dataflow Name="<#= worksheet.Replace("$",  "") #>" DelayValidation="true">
    <Transformations>
      <ExcelSource ConnectionName="Accidents Source File" Name="XLS Accidents - <#= worksheet.Replace("$",  "") #>">
        <DirectInput>SELECT * FROM `<#= worksheet #>`</DirectInput>
      </ExcelSource>
      <OleDbDestination Name="OLEDST Accidents Table" ConnectionName="AccidentData DB">
        <ExternalTableOutput Table="[dbo].[AccidentData]"></ExternalTableOutput>
      </OleDbDestination>
    </Transformations>
</Dataflow>
<# } #>