We are currently running SQL Server 2014 and are in the process to upgrade to SQL Server 2019. All SSIS projects were created with Visual Studio 2014. What is the best way to upgrade the 2014 projects to 2019 and which Visual Studio project is the best to use? Will the community edition do what we need, or do we require VS2019 Enterprise? Because we need to make some changes to some of the connections, we cannot just do a straight upgrade, we need to upgrade and then edit the projects as well before deploying.
In fact these are my mistakes that VS 2019 showme:
Error: SQLSTATE: 22018, Message: [Microsoft][ODBC Oracle Wire Protocol driver]Invalid character value. Error in column 3.;
Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. Oracle Source Output]” failed because error code 0xC020F450 occurred, and the error row disposition on “ORA SC MV_CP_ENTIDAD_FED_CONS” specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on ORA SC Oracle Source returned error code 0xC0209029. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Any help will be highly appreciated.
Read more here: Source link