thanx for the help

the out put need to be like this :

PurchaseOrder Table

Id BuyerName ...

sorry for got to add my sample xml

PurchaseOrder BuyerName=“Car Corporation” Date=“1 Jan 2000”>

<ItemsBought>

<Item PartId=“1” Cost= “3000”/>

<Item PartId= 2” Cost=“6000”/>

</ItemsBought>

<Payments>

<Payment CreditCard=“8342398432” ChargeAmt=“8000.00”/>

<Payment CreditCard=“3474324934” ChargeAmt=“2000.00”/>

</Payments>

</PurchaseOrder>

Hi

thanx guys my Report is working nicely now.

Hi nigelrivett

thanx for ur help u are Right a added an Replace and is working fine now

"INSERT INTO [SIT].[dbo].[FileNameError] ([FileName],[ErrorCode] ,[ErrorDescription])

VALUES('"+ (DT_STR,255,1252) @[User::ErrFileName] +"'," + (DT_STR, 15, 1252)...

sorry about the post before this is what i need to do plz help

i have a table that have info stored like this :

ID ...

hello

what i need to do is select this xml from the column in a table where it is stored and insert the values form that xml into another table

Thanx this is working well ur a star

Hi

i'm sorry about that it work

Thanx a lot:)

Hi

if i remove Top 1 it give me an error Subquery returned more than 1 value.

set @ItemID = (select top 1 ItemID from Item)

set @BandDate = (select...

Hi

but it does not check all the the rows to see if its 1 or 0 if take very row as if it have only 0 coz i'm using...

thanx it worked u guys are stars:D

Hi All

but i need to update all the rows where @Approved is >= getdate() if i use TOP1 will tht work?

Hi Preetha

Thanx a lot it work

regards

Nosi

Hi Preetha

which component can i use for the code u just send me

regards

Nosi

Hi All

thanx for your help.

If i use Execute Process Task how is the user of the package going to be able to supply the location to where the zipped...