Haven't tried it yet, but why would you want to access Oracle as sysdba through linked server?

Isn't it possible to grant the user the specific rights for their needs?

Start reading the oracle concepts

and DBA 2 day course

As above, talk to your manager about priorities and stop taking work to home.

If possible get some training time so you won't have to do training in personal time, so...

SQL Server days (2 days) just passed and was great. How do you prepare for pass summit with 5 days of awesomeness?

source data is on another server ?

More like a linked server setup (run package on server A to access data from server B)?

I have something like this

/****** Object: ProxyAccount [proxySSIS] Script Date: 8/09/2015 16:12:43 ******/

IF NOT EXISTS (SELECT name FROM msdb.dbo.sysproxies WHERE name = N'proxySSIS')EXEC msdb.dbo.sp_add_proxy @proxy_name=N'proxySSIS',@credential_name=N'SSISProxyCredentials',

@enabled=1,...

localhost\instancename

localhost\port

(see ms sql server configuration manager)

is ms sql server browser service running?

Check on runtime settins like dateformat for datetime string conversions?

What is the output format of the report? html vs excel ...

CPU's disabled in BIOS?

Check out this forumpost, it mentions hyperthreading

Perhaps restricted by virtual machine manager?[/url]

sp_whoisactive

sp_who2

sp_lock

Hello,

You don't have to copy the snap-in line, only the code between

public void Main()

{

....

Dts.TaskResult = (int)ScriptResults.Success;

...

Did you try a reboot after installing the oracle clients?

Is the oracle client the latest from oracle support?

What happens if you place the package in a subfolder like c:\packages\ram.dtsx?

Got away with changing the connection from native oledb Microsoft Ace... to .NET Provider/Microsoft Ace...

Seems to work in the script component and sufficient for the small excelfiles.