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 |  
                                    | shaihanStarting Member
 
 
                                        20 Posts | 
                                            
                                            |  Posted - 2007-09-29 : 00:41:33 
 |  
                                            | i am transfering an Oracle 10g database to SQL Server 2005. i have 2 pcs one with SQL Server 2005 with SSMA For Oracle Extension 3.1 installed, also with Oracle 10g client configured to connect the Oracle database in another pc. the other pc has Oracle 10g database server installed with SSMA For Oracle 3.1. whenever i try to migrate the data there is an exception which says "Errors: SQL Server cannot access the source table"i dont understand why its there. i hav successfully converted the schema and loaded them in SQL Server. can anybody tell me a soltuion asap.S ]-[ /-\ | ]-[ /-\ N |  |  
                                    | rmiaoMaster Smack Fu Yak Hacker
 
 
                                    7266 Posts | 
                                        
                                          |  Posted - 2007-09-29 : 00:52:57 
 |  
                                          | Microsoft has knowledge base article for that, search their web. |  
                                          |  |  |  
                                |  |  |  |