Load data into XML file in XML format in SSIS2005

  • Hi,

    I am new in SSIS.

    RPV01,VJAAP,'TRUE'

    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

Viewing 0 posts

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