Connect to SAS Datasource

  • Hi, in DTS I used an ODBC connection to connect to SAS using the 'other data source' connection. How can I do the same in SSIS? Thanks.

  • This was removed by the editor as SPAM

  • I tried the .Net ODBC Data Provider to connect to the ODBC Source. Then I tried to use the DataReader Source connection. It seems like it picks up the columns in the data set, but gives this error:

    "ODBC Drive does not support this function"

    All I am doing is putting in the connection name and a simple "SELECT *" Query. Has anybody seen this or could lend a hand? Really appreciate any help. Thanks.

    -Pat

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply