Load data into XML file in XML format in SSIS2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Stan Kulp » Load data into XML file in XML format in...

Load data into XML file in XML format in SSIS2005

Rate Topic

Display Mode

Topic Options

Author

Message

Kishor_ren

Posted Wednesday, August 01, 2012 6:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 12, 2013 6:07 AM
Points: 1, Visits: 9

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

Post #1338486

« Prev Topic | Next Topic »

Permissions