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

I have the same question (0)

All responses (4)

Answers (0)

MSCRM Guru 600 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Tomar Sourabh 110 on at

Like (0)

Report

Thanks for reply.

I am using fetchXML in SSIS pkg. Any idea how can we achieve?

Was this reply helpful? Yes No
Suggested answer

Shahbaaz Ansari 6,211 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Abdelrhman Hiba 321 on at

Like (0)

Report

Hi Sourabh

Is this problem solved?

I have this problem

Was this reply helpful? Yes No