Flat file connection manager doesn’t work for rows containing “Embedded Qualifiers”

I came across an interesting issue related to Flat file connection manager which doesn’t work for rows containing “Embedded Qualifiers”. I have worked with two different partners and both were having the same issue so thought of sharing my experience with you all. Scenario and Issue: Consider that we have a source CSV file which…


SSIS packages executed through SQL Agent Job scheduler fails while connecting to Azure File Storage Path

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. While running this SSIS package from Visual Studio – SQL Server Data Tools (SSDT) & after deploying…


SSIS Scale Out worker is not showing up in Worker Agents

  Understanding of the issue: Adding the scale out worker to the master shows successful but this does not show up in the SQL Server integration services – Manage Scale Out (ISManager). Also, this will not be added in [SSISDB].[internal].[worker_agents] Adding SSIS worker completes in the wizard as below After this finished, if we check…