6:07 PM
@JohnK.N. Feel free to provide an answer. As I say, I'm dumb when it comes to what ain't English.
I think the issue isn't the file source but the OLE DB componentry not being aware of UTF-8. Database-wise, they just came out with that for 2019 so doesn't surprise me that SSIS isn't completely thought through
Would be a good thing to raise on user voice but I've given up on trying to affect change in MS products
@HannahVernon Pleasure to make your acquaintance. Happy rebirth day