Migrate SSIS packages, projects in visual studio from 2016 to VS 2019
I am new , involved in upgrade/migration of the SSIS projects , packages created in VS 2016 to VS 2019. I have installed the free Visual Studio 2019 Community version and Integration services project. and Sql Server management studio - 2019. I have…
SSIS - Excel Macro
Hello, I have an SSIS ETL that moves excel files from a local folder and inserts the data into a SQL database. I'm running into some issues with a the excel files being in two different formats breaking the ETL mappings. I've created an excel macro…
SSIS - Send Mail Task
Hello, I created an SSIS ETL that Loops through a local folder, inserts excel file data into a SQL db, then archives the file. I'm trying to add a Send Mail Task to the process but I can't seem to get it to work. I can get the email to run but it…
Unexpected Termination - SQL Agent - excel Import
Hi experts, According my research over google, this issue has been active since 2018. Unfortunetally I haven't found the right answer. I hope somebody could help me. I have a package in SSIS which loads an Excel file data into a Table. At the…
Where do I download SSDT July 2016 Update (ver. 14.0.60629.0) from?
I require a specific version of SSDT for my development environment due to the limitations of server software and other collaborators' environments. It has to be exactly SSDT version 14.0.60629.0 for Visual Studio 2015. I can not find a place to…
we hope Microsoft can develop databases like mysql
We would like to provide the installation version and the installation free version; MySQL only needs to read the configuration file to run without complex registry key.
SSIS Scale Out and its services on local group policies
As per MS recommendation, scale out master service and worker service accounts should be member of which local group policies ?