Limitations of the SSIS Excel Source/Destination SSIS comes with out-of-the-box support for reading and writing to Excel. However, it’s very restrictive if you want to make things dynamic, as any metadata inside DataFlow cannot be changed at runtime. Here are a few problems with using the native Excel Source or Destination. Metadata cannot be changed […]
Introduction SSIS PowerPack supports various methods for making things dynamic. Sometimes you have to consume JSON Data from a Dynamic URL. There are 3 different ways you can make JSON Source URL Dynamic. Use Expression on the DirectPath property of the JSON Source (SSIS Data Flow Expression) Use variable placeholders directly inside URL (Only works […]