May 1, 2024 at 3:06 pm
I have about 40 packages that are dtsx files that were created with SQL 2016.
It appears that I need to either install SNAC (which is decprecated / not recommended) or change them all to sql ole db. Is there an easy way to change to sql ole db?
May 1, 2024 at 3:09 pm
They should both support the same record set operations so change the connection providers and rebuild the project then test
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2024 at 3:53 pm
Use project-level connection managers, and then the change is required in one place per target.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply