Hi,
Have a SSIS package which is simply exporting from a table to a csv file. For debugging purposes, I created a new one and just kept the script component which first reads the data that I need to filter on. But keeps failing, below are the error that I keep getting-
- The component metadata for Script component could not be upgraded to the newer version of the component. The PerformUpgrade failed.
- The version of the Script Component is not compatible with this version of the Data Flow.The package was created with a new version of DTS or component than what is installed on the current PC.
- I get the same error as #2 for Flat File Destination
Sql where it is being deployed is 2017, VS is 2017 and using SSDT for VS 2017.
Have tried changing TargerServerVersion, it was at 2019, changed it to 2017 and tried other versions as well but to no avail. Even disabled 64bitrunTime as was suggested by some but again same errors.
Have even built the package from scratch, removed the flat file/script components and put them back again but no change in the errors at all.
Have even reinstalled SSDT 2017 but again same errors.
Forgot to mention: I get this error only when running it from Integration Catalog.And that too, when I have export it, remove the package from Integration Catalog and re-deploy the ispac file. If I copy this ispac project file to another server then also get the same error. It all works fine from within ssis or when I run it after the 1st deployment from SSIS.
Here is the error:
Any inputs would be highly appreciated.
Thanks