Exec SP in Execute SQL Task -XML result set

Question

Viewing 6 posts - 16 through 20 (of 20 total)

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

Gerbera SSCommitted Points: 1715 More actions · Answer 1

SSCommitted

Points: 1715

April 25, 2012 at 5:40 am

They have just used

Select ..... For XML PATH

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Ah, so there is already an XML generated inside the stored procedure.

Can't you try to execute the sp directly in an OLE DB source?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

I did some more testing and you need to use an ADO.NET connection manager.

Then you can use the Execute SQL Task and put the result set in a string variable.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Gerbera SSCommitted Points: 1715 More actions · Answer 4

SSCommitted

Points: 1715

April 25, 2012 at 7:12 am

Thanks Koen!!! That works 😀

Gerbera SSCommitted Points: 1715 More actions · Answer 5

SSCommitted

Points: 1715

April 25, 2012 at 7:31 am

Koen.,

It lookd like working.. But its not !

Gerbera SSCommitted Points: 1715 More actions · Answer 6

I recreated the ADO.NET connection and its working now !