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.
Answer by sanei05 ·
Hi, I am posting my finding as answer .
The package has 1st step to identify the flat file. I got to know the flat file was placed in wrong location from the variable analysis. Placing the file in the right location. SSIS package worked perfectly fine.