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.

There is likely a more detailed error description if you click it open.

Example

Executed as user: X\Y.

Microsoft (R) SQL Server Execute Package Utility Version 11.0.5592.0 for 64-bit Copyright...

Does the sql agent job account have rights on C:\Ram.dtsx? (on the sql server)

Thanks, I'll try it out

I was misinformed, SA not needed for downgrade ( volume licensing? )

MS SQL 2014 licensing guide

MS SQL 2014 licensing changes