Post reply

Connect to SAS Datasource

  • October 13, 2006 at 2:56 pm

    #114735

    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.

  • October 16, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • October 18, 2006 at 1:10 pm

    #666620

    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