August 3, 2011 at 3:36 pm
You may try and use the 'Microsoft OLE DB Provider for Oracle', it will probably honor the SQL Server collation setting.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
August 3, 2011 at 3:58 pm
Thank you very much for your response. Unfortunately, that is the drive I am using....
Annette
August 3, 2011 at 4:04 pm
The main problem is the provider you mentioned is not in the list of providers while creating the linked server. How to get the 'Microsoft OLE DB Provider for Oracle' ??
August 3, 2011 at 4:18 pm
You have to install Oracle client on the server.
then you can download this driver from Microsoft website:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=741
Annette
August 4, 2011 at 8:40 am
Try using an SSIS task to do the import. It will give you more control over the columns, it could help with your first problem.
Not sure about your second problem, though. How are you querying the Oracle database? Is it a SQL statement using the linked server as the table name or are you using OPENQUERY? Try both ways and see what happens.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply