I am usually pretty good at SQL Server, and have been able to create a linked DB to Oracle in the past, but things seem to be working differently in 2012. I cant get the connection to hold. I am at best a mediocre oracle DBA, and I have not created a trusted connection from there.

Do you know a link where I can get the instructions?

>As this is a migration you can create a trusted connection on Oracle 11g database. This will help you to migrate then in the new sql server 2012 reestablish the proper security.
>
>>I am trying to find the best way to migrate an Oracle 11g DB to SQL Server 2012 on a Windows 08R2 hardened server. Both DB engines are on the same box.
>
>>I have tried to set up a connection in SSIS and the connection tests fine, but when I try to import a table the connection fails due to user validation problems. It >seems the connection definition will not keep the pw, even though I tell it to save the pw.
>
>>I have downloaded MS SQL Server Migration Assistant (5.2) for Oracle, but am unable to get it to install without crashing the server.
>
>>It is getting very frustrating at this point. Any help will be greatly appreciated.
>>Thank You
>
>>Rollin Burr
>
>>Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.