At least have a read of this link:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8afed667-4b3b-4a1b-8c81-f2d039e974bb/use-ssis-to-read-files-in-sharepoint-library?forum=sqlintegrationservices

Not sure if that will help, but it may at least point you in the right direction.  ...

Then chances are, your new value still violates the FK constraint.   Check the table referenced by the FK for the value you're looking to insert and see if it's there.  ...

Just curious if another approach might work.   If these dates are confined to a relatively short overall range, say 20 years, ...  this ITVF might work well:
CREATE FUNCTION dbo.YEARDIFF...

Just curious as to why a DATEDIFF(year, FirstDate, SecondDate) doesn't work for you?

Here's a query that will do what you need.   Recursion isn't really going to help you for this, as you're not dealing with a hierarchy or similar structure:
-- ORIGINAL...

This appears to be a duplicate posting.

Well, cursors are loops...  if not written correctly, they can go into an infinite loop, but as you say it only occurs on Monday mornings, it seems more likely that...

And how much fun would...

As you posted in the SQL 2016 portion of the forum, I had presumed you were using that version of SQL Server.   As to my case, my system will simply...

jorge_vicente,

How much slower will depend heavily on the nature of the calculation.  How much that ends up costing overall will then further depend on the number of records...

Are you current on service packs for SQL 2016?    I don't have a 2016 instance to check anything out with, but I do have a 2012 instance that I tried...

I'm not sure the ACE drivers are going to support executing a sproc.  Given that it's a simple select, using a sproc seems totally unnecessary.  If it were a more...