Limitation of SSIS Excel Source/Destination SSIS comes with out of the box support for read/write to Excel. But its very restrictive if you want to make things dynamic because any metadata inside DataFlow cannot be changed at runtime. Here are few problems using native Excel Source or Destination. Metadata cannot be changed at runtime Datatype […]
Introduction SSIS PowerPack supports different ways to make things dynamic. Sometimes you have to consume JSON Data from Dynamic URL. There are 3 different ways you can make JSON Source URL Dynamic Use Expression on DirectPath property of JSON Source (SSIS Data Flow Expression) Use variable placeholders directly inside URL (Only works when you use […]