Connectivity problem

Question

Post reply

Connectivity problem

SQLBuddy123

One Orange Chip

Points: 28294
More actions
July 10, 2009 at 8:03 am

#131885

Hi,
Could anyone tell me that how to connect to and how to import data from a Oracle source using SSIS Package (From BIDS) on a 64 bit Windows with 64-Bit SQL Server 2005?
Thank You,
Yours,
SQLBuddy.

Viewing 11 posts - 1 through 10 (of 10 total)

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

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

I would start at:

Microsoft Connectors for Oracle and Teradata by Attunity

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

As to whether they are 64-bit or even SQL 2005 SSIS, I can't say.. But this is where I would start..

CEWII

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 2

Hi Elliott,

Thank a lot for your reply.

But I think the link is related to SSIS 2008.

Yours

SQLBuddy.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

I think in the cases of OLEDB providers I'm not sure whether there really is a 2005 or 2008 except for the SQL DB Engine.. The MS DB2 OLEDB provider is the same..

CEWII

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 4

Hi Elliott,

Thanks a lot for your reply.

I am still strugling with that issue.

Yours

SQLBuddy

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

I guess I'm wondering where we are in this process, do we have anything working, have we made any progress, please advise.. I've been busy during the day, its been hard to answer questions..

CEWII

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 6

Hi Elliott,

Finally, I was able to connect to the Oracle datasource using BIDS on a 64-bit machine. In the beginning it posed a number of problems.

What I did was, I installed 32-bit oracle client , changed the environment variable path and executed the package at the command prompt using dtexecui. Everything went fine.

Yours

SQLBuddy.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

I'm like 99% sure that BIDS is only 32-bit, so it should work great with those drivers.. I just found this:

http://geekswithblogs.net/nestor/archive/2008/01/22/118792.aspx

Take a looksee..

CEWII

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 8

Hi Elliott,

Thank you very much for your reply.

Just check these if you have some free time.

http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=11

http://portal.sqltrainer.com/2007/11/sql-server-integration-services-oracle.html

http://stevemchugh.blogspot.com/2007/02/adventures-of-ssis-and-oracle-in-64bit.html

Yours

SQLBuddy.

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 9

Just did this myself. Downloaded and installed the 64 and 32 bit clients and it works

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 10

Hi SQL Noob,

Great Job!

Thanks for your reply.

Best Regards,

SQLBuddy