Export a table in SQL Server 2005 to SAS 9.1.3

[alanj]

Greetings.

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 ?

Thanks.

alan

[Vince_SAS]

This looks like something that would be better handled by our Technical Support staff. You can open a track online at:

http://support.sas.com/ctx/supportform/index.jsp

Vince
SAS R&D