Post reply

reading values from orcale db and assigning to varibales in sql server

  • November 13, 2008 at 6:05 am

    #126873

    i want to read two date values from orcale database and assign these date values to variables defined at DTX package level and use the value assigned to filter the data from SQl server tables using Execute SQL task. Please somebody help me, it is very critical.

    what are the parameters i need to set.

    i am calling the procedure at oracle to return the two out parameter valuies which i want to assign to two variable that i have defined in SSIS.

    i am getting following errors

    [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_None".

    Even though i triesd with other options availabel still i am getting the error

    Error: The type of the value being assigned to variable "User::fromdate" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

  • November 13, 2008 at 6:21 am

    #898019

    to assign sql results to variables, you need to set the result set to single row and in the resultset tab add in the two variables to which you wish to assign the values. The result name should be the index of the column from which the value is coming, i.e. 0 for the first column, 1 for the second, etc.

    Tom

    Life: it twists and turns like a twisty turny thing

  • November 16, 2008 at 8:43 pm

    #899140

    Thanks for replying. still i am getting the errors.

    i have set the resultset to singlerow and variables in result name as 0 &1 but still i am getting the error. i am attaching the configurations.

    please have a look and advise. i have been strugling a lot to make the things work. actually this is the first tiem i am working with SSIS.

    Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "declare FromDate varchar2(10);

    ToDate varchar2(10);

    begin

    PR_GET_EXP_DATA_LOAD_DATES( FromDate, ToDate);

    end;

    " failed with the following error: "Parameter name is unrecognized.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Task failed: Execute SQL Task

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply