Visual studio 2015 Jan 2021 update broke my SSIS ETL package

Herman Vorster 1 Reputation point
2021-03-25T14:17:57.877+00:00

Good day,

Each month (on the 1st) I run a SSIS package to move data from Oracle to MS SQL Server.

The source connection is a Native OLE DB\Oracle Provider for OLE DB and Destination Connection is a Native OLE DB\SQL Server Native Client 11.0

This was working perfectly up until this month.

I have an Oracle SQL script combining data from 3 tables.

  • Table 1 = Transaction details
  • Table 2 = Calculation Details
  • Table 3 = Rollup Details

When I run the code in Oracle I get all the data. When I plug it into SSIS and I preview the data, I get all the data, when I run the ETL package for specific people, I get all the data.

The problem comes in when I run it for all the people in our organization. I get all the columns but only data for table 1 is persisted into the MS SQL table.

Here is what I tried:

  • Run the package as 32 bit - Run64BitRuntime = False
  • Change the OLE DB Source and Destination to ADO Net connections
  • Made sure the datatypes of the tables joins are the same
  • Run the package for a specific month. The date range is normally 2 years (48 Million lines)

Windows updates happened as follows:

  • update for Office 2010: March 9, 2021 (KB4504703) = 2021-03-13 installed
  • Security update for the Diagnostic Hub Standard Collector elevation of privilege vulnerability in Visual Studio 2015 Update 3 (KB4584787) - Installed 2021-03-13

I am sure it has something to do with these updates as this wasn't an issue when I executed the packages on the 2021-03-01

I am not sure what to do any more and need some guidance.

Thanks in advance,
Herman

Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
938 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dylan Zhu-MSFT 6,406 Reputation points
    2021-03-26T08:59:59.26+00:00

    Hi HermanVorster,

    Since the warranty support of visual studio 2015 is end, we suggest you migrate back to previous version of visual studio 2015.

    https://learn.microsoft.com/en-us/lifecycle/products/visual-studio-2015
    https://learn.microsoft.com/en-us/lifecycle/policies/fixed#extended-support

    Best Regards, Dylan

    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.**

    0 comments