Prerequisite

Step by step configuration

Step 1: Update Excel configuration file

There is an Excel ‘Configuration.xlsx’ in the download zipped folder. This Excel configuration file has two sheets. What to fill in each sheet is mentioned below in detail. Please find below Excel configuration file with sample values.
excelImage.png

ServerDetails:
Provide all required connections (ConnectionName, Source, Destination etc.) for all SSIS packages. One row for each connection. These connections are OLEDB connection available at package level (not at project level).
ServerDetails.png

Config:
Source data pull details. One row per data pull. Each row will create one Sequence Container in package.
config.png

Step 2: Generate SSIS packages

  • Create a new SSIS project
  • Add file ‘GenerateSSISPackage.biml’ (File is given in downloaded zipped folder) in the Project
solution.png
  • Edit ‘GeneratePackage.biml’ file and update Excel configuration file path (provide absolute path)
BIMLCode.png
  • Right click on GenerateSSISPackage.biml file and select Generate SSIS Package
generatePackage.png
  • You are done and your package has been created
PackageCreated.png
  • Generated package may look like sample shown below:
SamplePackage.png

Last edited Jan 11, 2014 at 7:21 PM by braveson, version 15