Thanks Grant.

That's what I figured and I created Resume/Pause ADW Runbooks using Powershell. But calling ADF pipelines into Runbook is giving me hard time, and I am very...

I think my project got corrupted, when I create in new project, not seeing this exception anymore.

Anywayz thanks for helping Phil.

Thanks for your reply guys.

That's the tough part, I have barely one column and generating rest of the columns using it.

I generated flag based on Date...

Thanks Ray!

So I will compromise on it, need to check with my boss 🙁

Thanks Ray!

It worked like a charm 🙂

I stuck up with one more issue, merging cells vertically. I am not seeing this option when I select two columns vertically by right-clicking...

Thank you everyone. Queries passed successfully.

Can anyone please look into it

Thanks for your reply.

Can you please be in detail, how to lookup the recordset variable from foreachloop container.

Thank you Matt, Luis

It saved lot of my time.

I am sorry for giving reserved columns. Those are not my real columns. I have large number of columns, just to make...

Yes you are right. I am exporting from sqlserver to csv file.

I tried pipe as column delimiter. It's not working too.

Can you please try to test once with the value...

Thanks for answering..

Could you please tell me....how query looks if I need to append Effectivedate column(tblB) to the result set...