I have downloaded the SQL Server Integration Service and installed in Visual Studio 2022. When I create a project with one Excel file as the source and an OLE DB destination, it's working and rows are inserted into the database.
But when a derived column section is dragged between them for running simple UPPER string function, during the run of the package, it throws an error:
Error: 2024-01-21 08:09:24.81
Code: 0xC000F427
Source: Data Flow Task SSIS.Pipeline
Description: To run a SSIS package outside of SQL Server Data Tools you must install Standard Edition (64-bit) of Integration Services or higher.
End Error
While creating this project, it's working fine and all the excel data was inserted into the database table student.
I choose OLED DB provider for SQL Server:
And it's working fine.
I tried to integrate SSIS project in Visual Studio 2019 but it still throwing the same error.