How to pass multiple values dynamically to IN operator in Fetch XML while executing it through SSIS?

(0) Share

Report

Posted on by Tomar Sourabh

110

Hello All,

From the first fetchxml i got the data(suppose 10 GUIDs). I want to execute second fetchxml in which i want to pass data(10 GUIDs) in IN query.If i hard code the parameters in the IN operator its work fine but is there any way to pass data dynamically?

*This post is locked for comments

All responses (4)

Answers (0)

Abdelrhman Hiba 321 on at

Like (0)

Report

RE: How to pass multiple values dynamically to IN operator in Fetch XML while executing it through SSIS?

Hi Sourabh

Is this problem solved?

I have this problem
Suggested answer

Shahbaaz Ansari 6,203 on at

Like (0)

Report

RE: How to pass multiple values dynamically to IN operator in Fetch XML while executing it through SSIS?

Hi Tomar,

Add all the Guid in array and pass into your In Operator in fetchxml query.

Hope it help!

If it helps you,mark my answer as verified.

Thanks,

Shahbaaz
Tomar Sourabh 110 on at

Like (0)

Report

RE: How to pass multiple values dynamically to IN operator in Fetch XML while executing it through SSIS?

Thanks for reply.

I am using fetchXML in SSIS pkg. Any idea how can we achieve?
MSCRM Guru 600 on at

Like (0)

Report

RE: How to pass multiple values dynamically to IN operator in Fetch XML while executing it through SSIS?

Hey Tomar,

How are you doing this? C#? JS? Workflow?

You should be able to construct the FetchXML structure for the In operator fairly simply in most languages before sending it to the server.

Good luck!