question

HermanVorster-9772 avatar image
0 Votes"
HermanVorster-9772 asked DylanZhu-MSFT answered

Visual studio 2015 Jan 2021 update broke my SSIS ETL package

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


vs-debugging
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Forgot to add something, the package completes without any errors every time it runs.

0 Votes 0 ·

1 Answer

DylanZhu-MSFT avatar image
0 Votes"
DylanZhu-MSFT answered

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://docs.microsoft.com/en-us/lifecycle/products/visual-studio-2015
https://docs.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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.