July 7, 2009 at 10:51 pm
Hi,
I have created one variable called Effectivedate then i set Evaluate Expression as False and assigned default value '20/03/2009' type as string
then i have created another variable Preparesql and i have set evaluate expression as True then assigned the following query to that expression
SELECT POSITION.SECURITY_ALIAS,POSITION.DEP_ACQ_DATE,POSITION1.ORIG_FACE FROM (SELECT LLP.SECURITY_ALIAS AS SECURITY_ALIAS ,CONVERT(VARCHAR(8),LLP.department_acquisition_date,112)
AS DEP_ACQ_DATE FROM HOLDING.DBO.POSITION P, HOLDING.DBO.POSITION_DETAIL PD, HOLDING.DBO.LOT_LEVEL_POSITION LLP
WHERE P.POSITION_ID = PD.POSITION_ID AND P.POSITION_ID = LLP.POSITION_ID AND PD.security_alias = LLP.security_alias
AND P.SRC_INTFC_INST =(SELECT INSTANCE FROM PACE_MASTER.DBO.INTERFACES WHERE SHORT_DESC='DD') AND
CONVERT(VARCHAR(8),P.EFFECTIVE_DATE,112) =("+ @[User::Effectivedate] + ") ) POSITION LEFT JOIN ( SELECT LLP.SECURITY_ALIAS AS SECURITY_ALIAS, LLP.ORIG_FACE FROM HOLDING.DBO.POSITION P, HOLDING.DBO.POSITION_DETAIL PD, HOLDING.DBO.LOT_LEVEL_POSITION LLP WHERE P.POSITION_ID = PD.POSITION_ID AND P.POSITION_ID = LLP.POSITION_ID AND PD.security_alias = LLP.security_alias AND P.SRC_INTFC_INST =(SELECT INSTANCE FROM PACE_MASTER.DBO.INTERFACES WHERE SHORT_DESC='BLACKROCK')AND CONVERT(VARCHAR(8),P.EFFECTIVE_DATE,112) =("+ @[User::Effectivedate] + "))POSITION1 ON POSITION1.SECURITY_ALIAS = POSITION.SECURITY_ALIAS
then i created the OLEBE command and used sql command from variable option.
Data flow task is executing successfully but it is not pulling any record.
can someone guide what could be the problem?
Regards
Senthil
July 8, 2009 at 1:43 am
I converted the variable effectivedate into DT_WSTR,10 then it is working thanks
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply