Hi all...
I have been struggling to complete my package from last 3 days.
The issue is I am using Oracle as source and oracle 9i client is installed on my system and SQL serve r database.
In my connection string I have used Microsoft OLE DB for Oracle. My package runs fine on BIDS but it gives error when run thru dtexec or SQL agent and the error is :
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
No idea of what to do. I have created a sample Agent where source and destination are SQL server and it works fine.
Protection leve : EncryptAllwithPassword
Updated the connection string in configuration file and the Command line utility in SQL Agent
DECLARE @returncode int
EXEC @returncode = xp_cmdshell 'dtexec /f "D:\Satishtest\sample.dtsx" /config "D:\Satishtest\sample.dtsConfig" /De "p@ssw0rd"'
this is my SQL comand.
Please help me..... its urgent