Hi I have a dtsx file. It does check for the csv file, extracts, perform data conversion from CSV file to table and then loads the data into the database. This SSIS package has external configuration file with the file path, database names, file name as variables. It was working perfectly fine until last month when testing. But when I tested the package again . i noticed the validation steps and process for Input file check complete but the execution of sql queries in the database are not happening. I am running this package using dtexec.exe utility.
i tried using DTEXEC.exe utility for both 32 bit and 64 bit but still same error.
SQL Server version is 2016 Standard.
Can you please help why the SSIS package is not executing the SQL queries. I checked the reports in Verbose mode but I dont see any error. It give me SUCCESS message with no update to the database.
To add more details, I have Integration services installed on this DB Server. I do not want to use SSISDB as I am planning to running the job via external tool using batch script. So, I am using DTEXEC.
I do not have visual studio installed on the server to check the package in Debug mode or to run individual scrip task.