solution:

select Pie.CatId.value('@CatalogueItemID','CHAR(8)') as CatalogItemID,

Pie.CatId.value('ProductSalesRank[1]/@__Value', 'INT') as [Sales Rank]

FROM

@x.nodes('/ProductInformationEnhancementsDS/ProductInformationEnhancements') as PIE(CatId)

Seems quite interesting.

It would be nice if this could reverse/generate the visual interface to the package.

Also, I notice that some of the panes are not re-sizable, which is irritating when...

What is your expected return? 1 row or multiple?

What is the error message?

In my (relatively limited) experience:

If you are integrating applications, use Biztalk

If you are integrating data, use SSIS.

So, if you have to take an excel spreadsheet, and transform it, insert it...

Hi Gregg,

Thanks for the response.

The spreadsheet data will only be used for new/changed riows - we don't want to delete existing rows that are not in the spreadsheet. Additionally, because...

Good to know. See how much fun you get, running 64bit 🙂 MNaybe I'll have some of that 'fun' some day.

btw, typically, C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn will be in you path, and thus a simple dtexec.exe (or even dtexec) will work. Certainly, this is true in my environments

Sorry to say that I've had no chance to play around with 64bit, so I'm going to be 0 help to you I'm afraid.

Welcome to the fairly NON-exclusive club of people who have used SSIS, and had struggles with ProtectionLevel.

In years to come, we'll look back and laugh ... or maybe cry...

Imho, it sounds like that may be a bit of an overkill. I assume that the proxy and credential script I posted didn't help?

Florence, I would recommend (unless you've tried,...

While I don't know anything about Progress, it does sound like you need to check that it had access rights.

Is the Progress DB on a different server?

What user is specified...

Hi Florence,

What are the specific problems you are having? What is your environment setup?

I'll see if I can help, although it is a bit of the blind leading the...

great, thanks Noggin - I'm going to play around with that. Since I'm a virtual virgin with .Net, Weould it be alright if I ran a question ro 2 past...

Hi Noggin,

thanks for the response.

I'm currently look at a stored procedure that I had hoped would be able to include the XML header as part of the XML result returned....

XML required:

?xml version="1.0" encoding="utf-16" ?

PromotionRuleSet

RuleSetText ![CDATA[Rule 1]] /RuleSetText

/PromotionRuleSet

--I'm afraid adding the GREATER THAN and LESS THAN tags, amkes the text invisible!

What I get atm:

PromotionRuleSet

RuleSetText ![CDATA[Rule 1]]...