list of variables under SSIS 2005

Last Post 11 Jul 2007 01:14 AM by smael51. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
smael51
New Member
New Member

--
11 Jul 2007 01:14 AM
Hello,

I work on SSIS 2005, and I would like to know how given SSIS the order of passage of a variable.
Indeed, for example, I replace the parameters of the following request:

SELECT MAR_VAL_CRI FROM INT_MAR_EXP_PAR
WHERE MAR_COD_FLX = 'PNL'
AND MAR_COD_TAB = 'SAS_TRC_REF_RSC'
AND MAR_LAB_CRI = 'CODE SERVICE1'
AND MAR_COD_TYP = 'I'

by points of interrgations (?) => So that it takes into account variables

SELECT MAR_VAL_CRI FROM INT_MAR_EXP_PAR
WHERE MAR_COD_FLX = '?'
AND MAR_COD_TAB = '?'
AND MAR_LAB_CRI = '?'
AND MAR_COD_TYP = '?'

However when I affect each parameter (Parametre0=Variable0;Parametre1=Variable1; Parametre2=Variable2; Parametre3=Variable3 with my variables, SSIS does not follow the order of affection, but an order which is clean for him.

When there is only one variable, SSIS goes very well, on the other hand from 2, it goes less better and 3 he goes any more. I think that it must inevitably exist a solution to use several variables and thus to leave the choice to the user (with a table which will contain the list of choice.

Thank you in advance

You are not authorized to post a reply.

Acceptable Use Policy