Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE DB Connection Issue

Status
Not open for further replies.
QuestionAsker

QuestionAsker

MIS
Mar 9, 2006
4
0
0
GB
ALL

SQL 2005 Enterprise
Windows 2003 Server

I'm trying to connect to an Oracle 9i table with SSIS. I have connected to all the tables i need to in the same DB no problem, but when i try and access one table i get the following error message.

rror at Data Flow Task [OLE DB Source [492]]: An OLE DB error has occurred. Error code: 0x80004005.

Error at Data Flow Task [OLE DB Source [492]]: Opening a rowset for ""CVC"."ACM02"" failed. Check that the object exists in the database.

(Microsoft Visual Studio)

I can access this table no problems using the toad client, but it just wont happen in SQL server.

Any ideas?

thanks in advance
 
Status
Not open for further replies.

Similar threads

Lost500
  • Locked
  • Question
Upsizing access 2007 db to SQL 2005: ODBC connection failed
Replies
1
Views
35
bburnell
bburnell
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
61
okcorral
okcorral
williey
  • Locked
  • Question
OLE DB Connection in SSIS Package does not save password
Replies
0
Views
33
williey
williey
jcaulder
  • Locked
  • Question
Changing connection datasource in loop 1
Replies
3
Views
38
AlexCuse
AlexCuse
Bren2
  • Locked
  • Question
Ole DB Provider on SQL 2000 connecting to SQL 2005 express
Replies
1
Views
18
Bren2
Bren2

Part and Inventory Search

Sponsor

Back
Top