Feb 09 2021 02:43 PM
Has anyone created an import from maxdb to MS SQL? I tried creating an ODBC connection and can query/import into excel but cannot connect and import into mssql.
Feb 09 2021 10:31 PM
but cannot connect and import into mssql.
@Andyw2115, how do you try to import the data to MS SQL Server? What happens when you try it? Do you get an error message?
SSIS is a good ETL tool to transform and load data; have you tried it with a SSIS package?
Olaf