Your SAS programs, embedded in web apps and elsewhere

Export a table in SQL Server 2005 to SAS 9.1.3

Reply
Occasional Contributor
Posts: 7

Export a table in SQL Server 2005 to SAS 9.1.3

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
SAS Employee
Posts: 285

Re: Export a table in SQL Server 2005 to SAS 9.1.3

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
Ask a Question
Discussion stats
  • 1 reply
  • 181 views
  • 0 likes
  • 2 in conversation