We have a Windows Server 2003 running Unidata 5.4. Currently there is a SQL Server 2005 instance running DTS packages in legacy mode to extract the Unidata data via a UniData ODBC 3.1.6 connection. The application running on the Unidata database is 20 years old...
I have been asked to look at extracting the data using SSIS in SSDT 2017. Is it just a case of installing the UniData ODBC driver on the SSIS server and away I go?