I get an error message trying to use the IOM driver to transfer a table from SQL Server to SAS. I specify _local_ as the datasource, both SAS and SQL Server are installed on the machine, and get:
Cannot get string literals from the database connection...
Object reference not set to an instance of an object (DTSWizard)."
I am running Base SAS only on the machine. Should I specify the connection to SAS differently ?