Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2008-04-10 : 03:27:20
|
| Hi Pals,We have an SSIS package within which we are calling a stored procedure which eventually call a sql server dbo.fn() which contains code to lookup data inside oracle using Linked Server for Oracle.We are calling the Package dynamically from the stored procedure by creating a SQL Server Agent Job, I am getting the below error very often. Can we fix the error in any way?“EXEC sp_UpdateTname 369,'939390',2008 " failed with the following error: "Cannot initialize the data source object of OLE DB provider "MSDAORA" for linked server "ORATEST".". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.When I hard code global variables and ran the package I am able to see the successful execution of the package.Can anybody point out where could the error lies? |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-04-10 : 05:53:04
|
| I am also using XML configuration for the SSIS Package.Will that affect on Linked Server? |
 |
|
|
|
|
|
Linked Server Error !!!