https://communities.sas.com/t5/Microsoft-Integration-with-SAS/integration-services/m-p/24787#M494 Hi, <BR /> <BR /> I'm working on a new project trying to test the connectivity between sql server 2008 and SAS. <BR /> I'm trying to have a job created in visual studio (VS) to import SAS data to a sql server database. But I have a lot of trouble to configure the odbc connector. <BR /> Different drivers are visible in the connection manager : iom data provider, olap data provider 9.1, ole dp for olap provider for sas, local data provider, ...<BR /> The problem is when VS asks me to choose a table he gives a really nice error.<BR /> the requested collection (tables) is not defined. (system.data) Could not retrieve the table information. <BR /> can someone tell me how to retrieve data?<BR /> <BR /> This is not a solution : upload the data from sas to sql server... <span class="lia-unicode-emoji" title=":winking_face:">😉</span><BR /> <BR /> thanks a lot Wed, 29 Apr 2009 09:11:30 GMT mojerry 2009-04-29T09:11:30Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/integration-services/m-p/24787#M494 Hi, <BR /> <BR /> I'm working on a new project trying to test the connectivity between sql server 2008 and SAS. <BR /> I'm trying to have a job created in visual studio (VS) to import SAS data to a sql server database. But I have a lot of trouble to configure the odbc connector. <BR /> Different drivers are visible in the connection manager : iom data provider, olap data provider 9.1, ole dp for olap provider for sas, local data provider, ...<BR /> The problem is when VS asks me to choose a table he gives a really nice error.<BR /> the requested collection (tables) is not defined. (system.data) Could not retrieve the table information. <BR /> can someone tell me how to retrieve data?<BR /> <BR /> This is not a solution : upload the data from sas to sql server... <span class="lia-unicode-emoji" title=":winking_face:">😉</span><BR /> <BR /> thanks a lot Wed, 29 Apr 2009 09:11:30 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/integration-services/m-p/24787#M494 mojerry 2009-04-29T09:11:30Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/integration-services/m-p/24788#M495 Did a forums search and found this prior thread - suggest you contact SAS Support, open a tracking issue, and get a current reading on available options for your post.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <A href="http://support.sas.com/forums/thread.jspa?messageID=590" target="_blank">http://support.sas.com/forums/thread.jspa?messageID=590</A> Sat, 30 May 2009 13:46:35 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/integration-services/m-p/24788#M495 sbb 2009-05-30T13:46:35Z