Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mateo958
Starting Member
14 Posts |
 Posted - 2010-11-17 : 05:02:00
|
Edit : This problem is resolved, go to 2nd postHello,In my project i want to compare two source of data.I want to make a Lookup between the two source but in the first source I have an ID, and in the second source I have a label.The label correspond to an ID.In a xls file, I have the correspondance between the id and label. In my package, I want to add an column to my datasource with the label correspond to the id in my source. With a lookup, i can't compare to an ole db source but I can't with an xls source.What is the solution?Thanks |
|
|
mateo958
Starting Member
14 Posts |
Posted - 2010-11-17 : 10:54:22
|
| I resolved my problem with Microsoft Jet 4.0 OLE DB Provider.But I have an other problem with Lookup.I want to use a Lookup between a Dataset and an Oracle Database.And I have a "Warning" on my lookup."Cannot retrieve the code page info from the OLE DB Provider...When I execute my package I have these error.-----------------------------------------[Lookup [3056]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "PRDSIEB7.SIEBELCATS" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [DTS.Pipeline] Error: component "Lookup" (3056) failed validation and returned error code 0xC020801C. Progress: Validating - 100 percent complete[DTS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. Validation is completed[Connection manager "PRDSIEB7.SIEBELCATS"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft OLE DB Provider for Oracle" Hresult: 0x80040E4D Description: "ORA-01017: invalid username/password; logon denied ". -----------------------------------------In my connection managers, I can ping succefuly my Oracle database.In my Lookup, I add my query, and I can preview the result. So I don't understand why it can't connect to my database.ThanksPS : I'm sorry for my english... |
 |
|
|
|
|
|
Look up with Oracle