My bad, it is. I changed strAllRows to strFetchAllrows to make it more clear. I forgot to change in all the places.

Thanks for the quick reply. I think I should have mentioned it while posting the question. I'm not able to set the parameters to "ALL" or "NULL" or NULL from...

I think I got it. I created a dummy Identity column on TableC and used it as an unique index for my Full Text Index. And it works. 🙂

Both are integer columns(Item_Id int, Attribute_id int). And I'm trying to create the Full Text Index using SSMS(Management Studio). Unique index was created successfully. Trying to create Full Text Index...

Appreciate your help. Unfortunately for me, I cannot use hard coded values (18 like you mentioned). They come from the select query. I could achieve the intended result by moving...

Let me see if I understood the problem right.

You are trying to set a variable to true or false which will allow you to use in the file system...

Hi Scott,

I performed all the steps one by one and my pkg executed like charm. That was a great help.

Thank you very much.