I am new in SSIS.
I created Query like below
DECLARE @CustomerInfo NVARCHAR(MAX)
SET @CustomerInfo = (
Select ltrim(rtrim(RPVR01)) as RPVR01,SUM(RPAAP)*.01 as VJAAP ,'False' as Creditcashonly from TESTDTA.F03B11
where RPCO ='00100'
and RPAAP <> 0 and RPVR01 between '1' and '9999999999'
group by RPVR01
FOR XML PATH('CustomerInfo')
Select @CustomerInfo as text
but I am not able to load in XML using script task as per this Artical
some code issue
plz can any one give me exact code for this for SSIS 2005
thanks in Adv