Upgrade SSIS Visual Studio 2014 to 2019

Miguel Marin Solis 1 Reputation point
2021-10-08T16:33:37.353+00:00

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.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,772 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,716 Reputation points
    2021-10-08T18:24:43.19+00:00

    You can use the VS 2019 Community edition with the SQL Server Integration extension.
    https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

  2. KalyanChanumolu-MSFT 8,316 Reputation points
    2021-10-11T05:07:01.093+00:00

    @Miguel Marin Solis Thank you for reaching out.

    As suggested by @Tom Phillips , you can install the SSIS extension for Visual Studio 2019 and you should be good to go.
    On the same page, there is a list of additional components you will need to install in order to work with Oracle connectors.

    Regarding Visual Studio 2019 Community edition, please review the usage scenarios.

    In non-enterprise organizations, up to five users can use Visual Studio Community.

    In enterprise organizations (meaning those with >250 PCs or >$1 Million US Dollars in annual revenue), no use is permitted beyond the open source, academic research, and classroom learning environment scenarios described above.

    ----------

    If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.

    0 comments
  3. ZoeHui-MSFT 33,286 Reputation points
    2021-10-11T06:31:56.557+00:00

    Hi @Miguel Marin Solis ,

    Upgrade SSIS2014 to SSIS2019, you may refer the official documentation.

    Note that your datasource is Oracle, for SQL Server 2019, you could use Microsoft Connector for Oracle in SSIS.

    See here for details.

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments