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.
The question is this:
What package or software should I install to get the missing provider so I can run the mentioned service?
If you can please also tell me, where can I get that software or package?