Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
FOR EACH ERROR "User::order_ref" differs from the current variable type.

Answered FOR EACH ERROR "User::order_ref" differs from the current variable type.

  • Monday, January 21, 2013 8:49 AM
     
     
    Sign In to Vote
    0

    Hi All

    I need your help in SSIS ForEach task

    I'm have one some rows from SQL and i need to process them one by one.

    what i want that it should take first row and processed it then take second row processed it and so on.

    during updating tbale i get error

    [Execute SQL Task] Error: Executing the query "Update Input_Account_FPROT
    set ORDER_URL='https://..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    and on FOR EACH I GET THIS ERROR.

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

    kindly suggest something needful.

     

All Replies