We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Hi Everyone, in my package we are applying lot of synchronous and asynchronous transformations this is consuming lot of time to migrate. So, for this can we run package simultaneously on different servers , we are doing Full Migration i.e., one tim...

Hi Everyone, in my package we are applying lot of synchronous and asynchronous transformations this is consuming lot of time to migrate. So, for this can we run package simultaneously on different servers , we are doing Full Migration i.e., one time pr...

Hi Everyone, in my package we are applying lot of synchronous and asynchronous transformations this is consuming lot of time to migrate. So, for this can we run package simultaneously on different servers , we are doing Full Migration i.e., one time pr...

Hi Mitesh Modi , in Execute Sql Task --General tab- i set **Resultset = None** i am using Connection Type:**OLE DB** i gone through http://blogs.msdn.com/b/mattm/archive/2006/11/08/stored-procedures-with-output-parameters.aspx but ...

Hi Mitesh Modi thanks for your quick responce, as per your Suggestion , i created: user variable :x, datatype : int32 ,Value: 0, and in the Parameter Mapping as per your suggestion i added and i executed the package but error message: *...

what value we have to set for ResultName in ResultSet tab ,?...

Hi Mitesh Modi thanks for your quick responce, you mentioned **before end of procedure you have to write select query which return x as column with o or 1 as value** i changed procedure: CREATE OR REPLACE PROCEDURE Test143 (REC_COU...

Thanks Mitesh Modi for Quick response, i created a stored procedure CREATE OR REPLACE PROCEDURE Test143 AS c number(20); X number(20); BEGIN SELECT COUNT(*) into c FROM ba_account where NAME='UNK...

i run the package with above code error message is: **[Execute SQL Task] Error: Executing the query "declare c integer; begin select count(*) into c ..." failed with the following error: "ORA-06550: line 5, column 1: PLS-00428: an INTO clau...