How would you retrieve the content? Stored proc with Mars or a secondary db call for the sub items.

@eric

Simplified it for this but basically:-

ItemId int

ItemDescription varchar(255)

Currently, one or more of these items (up to 20 ish) would be loaded into memory in the app.

The new requirement...

@eric

I'll try and give more context.

Let's say current design allows for one or more items (db records and probs no more than say 20) to be printed via...

I was starting to think that MARS was a good idea but I understand that in SQL 2014 MARS is not allowed on in memory tables so I need to...

Thanks Eric for response.

Your right, to avoid a secondary call it could be wrapped up in one call (store procedure etc) but in the example you would have say the...

Yes - I think that's what i did and has been working well since, though I also think it may have been fixed in latest patches (I did a notepad++...

Hi - Yes I can. The only thing I've noticed but not sure if its related or not but the Web Service URL in 'RSCM Web Service URL' shows the...

Yes that works a treat:-)

I made the extra validation changes and noticed that the move of the name attribute also needed to be before the reference attribute as you've done...

Hi

Yes it is the same.

Attached is the parsing code that causes the error.

Thank you Grasshopper - this certainly helps.

I can get the data into two tables now.

My existing process also does a parse of XSD against the XML file before bulkimport of...

Hi, can anyone advise?

Thanks opc! Your we're spot on. I had Raise error statements against each line with the correct level, however when passing down to the error handling at the bottom (2000...

Unfortunately, found no fix at the time, so manually fixed all packages and has worked fine.

So just clicking on the Setup.exe wil install the 64-bit version by default because its on a 64-bit OS?

OK. Thanks guys for the posts, I meant bundled with Enterprise for example on the MSDN licence.

Do you happen to know if there are any changes to the Integration Services...