Specified provider is not supported IBMDA400
A Microsoft SSIS (Sql Server Integration Service, as a dtsx file) was handed to me by a fellow co-worker, but when I open it in Visual Studio 2019 and try to edit one of its connections I get an error “specified provider is not supported”. When I open the dtsx file in a text editor I can see it has, in various places “Provider=IBMDA400.Datasource.1”. I think that is the one provider I’m missing. It connects to an AS/400 server but I seem to be missing the needed provider.