August 8, 2011 at 10:15 am
Hi,
I've been trying unsuccessfully to pull SAS data into SSIS so I can create a report in SSRS 2008. I downloaded the latest version of the SAS ODBC driver. I know the driver is working because I can import the data from Excel using the SAS ODBC driver. I am now using the import/export wizard with Management Studio and when I get to the last step of the wizard, I get the below error message.
TITLE: SQL Server Import and Export Wizard
Column information for the source and destination data could not be retrieved.
"TESTLIB"."MYFIRST" -> [dbo].[SasTable]:
- Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
ADDITIONAL INFORMATION:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (System.Data)
Any thoughts or suggestions would be greatly appreciated.
September 14, 2011 at 10:25 am
Did you happen to get this working?
September 18, 2011 at 7:18 am
db2mo (8/8/2011)
Hi,I've been trying unsuccessfully to pull SAS data into SSIS so I can create a report in SSRS 2008. I downloaded the latest version of the SAS ODBC driver. I know the driver is working because I can import the data from Excel using the SAS ODBC driver. I am now using the import/export wizard with Management Studio and when I get to the last step of the wizard, I get the below error message.
Any thoughts or suggestions would be greatly appreciated.
can you try using BIDS?
Data Enthusiast | @SQLbyoBI | www.opifexsolutions.com
September 18, 2011 at 10:26 pm
You might want to look at a couple things:
1. What type of driver is it? Sometimes the driver will not show up because you are looking in one class data connections and it is in another. The SAS driver is a OLE source.
2. Is it only 32 bit and I am trying this in a 64 bit package? Rather pain in the neck I have seen with Sybase ASE. Quick google search seems to have a lot of issues trying to use the SAS 9.1 drivers with SSIS packages because they are running them in 64 bit.
The first line of code starts with coffee. The last line ends with alcohol.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply