SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path
First published on MSDN on Dec 01, 2017 Recently we ran into an interesting scenario where we had a SSIS package that contained a script task and inside the script task, we were making connections to Azure File Storage and pulling the data from the file.Creating dynamic SSIS package [Object model] and using OleDBSource & OleDBDestination internally fails in SSIS 2016
First published on MSDN on Dec 29, 2016 Issue:While dynamically creating SSIS packages using the object model and referencing the following SSIS libraries, you may receive the following exception thrownSSIS Libraries referenced:C:\Program Files (x86)\Microsoft SQL Server\130\SDK\Assemblies\ SqlServer.
