Awesome!! Thanks so much Thom for the solution provided. I will take a look at it and let you know if I have any questions.

Thanks again!!

Thanks Thom for the reply. I totally agree with you on SQL injection. Delimited strings will be a batter option.

Thanks Thom for the detailed explanation. We definitely need to build look up table to map column names to alias names. We need to parse through the where parameter and...

Thanks for the reply Thom. The code that I have pasted above use the Alias names. The "where" and "parameter" parameters come from the application. The application is aware of...

Thanks so much for the taking time to go through and reply. I should have given a proper example for better explanation of the scenario. I am sorry for that....

Awesome!! Thanks again Lowell. I think we will go with SSIS approach as we will have more control on data once we get it from remote local db.

Thanks...

Thanks a lot Lowell for granular level details. I want the SSIS package to reside on the central server along with the job and it has to pull data from...

Hi Lowell,
Thanks for your reply. The local db is not sharable. Each user will have his own local db and that needs to synced with central sql server. I...