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 |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2008-07-18 : 11:38:10
|
| All, I've a question regarding moving the Linked tables to Sql Server 2005 which are used in MS-Access 2000. These are linked tables where the driver is Microsoft ODBC for Oracle.I'm using these link tables in application in MS-Access. Now I'm trying to move to Sql Server using SSIS. When I tried to select the link tables which are in mS-access through the Import -Export wizard, the are not being selected only the queries which are written in mS-Access are being selected. My question is how to select the link tables in SSIS which are Oracle tables (I linked via ODBC). This is really urgent and help is appreciated.Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-18 : 11:45:24
|
| any reason why you dont want to get them by directly linking to Oracle? |
 |
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2008-07-18 : 11:53:20
|
| No reason, but how should I link them to Oracle when I move to Sql Server from MS-Access as I need to change the VBA code in Visual Studio 2005.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-18 : 12:00:14
|
quote:
Originally posted by swenri
No reason, but how should I link them to Oracle when I move to Sql Server from MS-Access as I need to change the VBA code in Visual Studio 2005.Thanks
I was asking whether your intention was to get the data onto sql tables? in that case, you could get data from oracle tables directly onto sql server and also other data from access onto sql server and then use quries in sql server to link them. |
|
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2008-07-18 : 12:21:25
|
| No the application that I'll be using still depends on the Orcale tables so I need to get the data from Oracle Tables and still be able to use in my queries in Sql Server to link them. How do I do it ? What are the steps that I need to follow. I need to get rid of using MS-Access because of the limitaions it has. Please let me know.Also I need to create reports based on these tables using SSRS that is the second task. Thanks, |
|
|
|
|
|
|
Problem using linked tables in SSIS 2005