Running my package which uses the Attunity Oracle driver pulling data from Oracle into SQL Server 2008: I can run the package from BIDS without a problem. I'm using my domain admin account to run all services and am logged in to the server running SQL Server 2K8 Enterprise using the same account. I created a SQL Agent Job using a Proxy account pointing to the same domain admin account. When I run the job using the agent, I get an error of: The component "Oracle" cannot run on installed Standard Edition of Integration Services. Why get this error only when running as an Agent job? And, why would it get thrown anyway since I'm using the Enterprise version to begin with?? Jeff

Yes, only the Enterprise version is supported, but do you run the package on the same server where the SQL Server Enterprise is installed? Running packages remotely does not count.Arthur My Blog

Did you run the package on the BIDS on the machine with standard edition of sql server and it works fine?http://www.rad.pasfu.com

Yes, I'm running everything on the server. Using BIDS on the server, it runs fine. Using the Agent under Management Studio I get the error.

I'm running everything on the server directly. I'm pretty sure I have the Enterprise version of SQL Server but I'm not sure how to tell if it's Enterprise or Standard. It doesn't say under the Help menu. js

how did you deployed package? on File system or SQL Server? if you deployed it on SQL Server, open SSMS, connect to integration services, set server name as machine name and then under saved packages, under msdb, find the package, then right click on it and execute it, what happens there? could you run it successfully there or not?http://www.rad.pasfu.com

I've tried it both ways. Just did it the way you suggested and it still fails but only when it gets to the part of the package where it makes a connection to the Oracle server using the Attunity Oracle driver. The error is: Error: component "Oracle Students" [31] failed validation and returned error code 0x80004005. js

maybe it is 64/32 bit issue. Try to run it with both DTEXEC 32 and 64 bit you can find 64 bit DTEXEC under this path: <system drive>\program files\microsoft sql server\<version>\DTS\binn\dtexec.exe and 32 bit under this path: <system drive>\program files x86\microsoft sql server\<version>\DTS\binn\dtexec.exe if you don't know how to run DTEXEC command line, look at this reference: http://msdn.microsoft.com/en-us/library/ms162810.aspx please let us know what is the result.http://www.rad.pasfu.com

Will that be different than using the "Use 32 bit runtime" choice under the Execution Options tab for the Job Step properties in the SQL Agent job?? I've tried it with that checked and unchecked with the same results. js

Will that be different than using the "Use 32 bit runtime" choice under the Execution Options tab for the Job Step properties in the SQL Agent job?? That's OK. weird thing, what did you set as protection Level?http://www.rad.pasfu.com

I've tried multiple settings. Right now it's set to "EncryptSensitiveWithPassword" otherwise I run into a different error of it not passing in the Oracle server password with the connection string. js

what version of Attunity you installed on the machine? 64 or 32 bit?http://www.rad.pasfu.com

64 bit, I'm pretty sure. js

could you try with 32 version of Attunity? note that unistall the 64 bit first and then install 32 bit. http://www.rad.pasfu.com

OK, I got the 64 bit uninstalled, the 32 bit installed but now when trying to make a new Connection Manager with the Oracle Provider for OLE DB, it will pass a Connection Test but when I try to save it, I get an error of "The given path's format is not supported" js

click on project in BIDS, then go to menu->project->properties in the new window, under debugging , set Run64BitRuntime to false and try againhttp://www.rad.pasfu.com

Same results - I can make a connection but can't save the Connection Manager settings. I always get an error of "The given path's format is not supported" when connecting to the Oracle server. js

weird results. I can't think about any other thing on this issue. but as a work around, maybe this be better to try with another data adapter, I suggest the Oracle Data Provider from here: http://www.oracle.com/technetwork/topics/dotnet/index-085163.htmlhttp://www.rad.pasfu.com