yep!

it worked

EXEC() has not got any limits.

try to have all the where condition in EXEC() then you will not have any prob with size.

thanks a lot!

in that case it should have threw error when i select few data in the parameters but it is working fine if i select few data

not in terms of tables, i need max size of dynamic query i can write.

like varchar(8000 ) can't i write more then this size?

thanks its working!

i tried even that.

Altered query

DECLARE @SelectedEntity as int

DECLARE @Region AS nvarchar(4000)

DECLARE @Country AS nvarchar(4000)

set @Region='A4037F-1067-DF11-84EF-0017A4776866'

set @Country='577A9867-1967-DF11-84EF-0017A4776866,577A9867-1967-DF11-84EF-0017A4776866'

SET @SelectedEntity =1

DECLARE @SQLFields1 AS varchar(8000)

DECLARE @SQLFilter1 AS varchar(8000)

set @SQLFields1='

select

Mu.om_muname as Region ,

cu.om_countryidname as...

great!

it helped me thank you .....

Koen,

got it:cool:

Thanks for the great support!

koen,thanks it was a great help!

but i am bit confused now like which file class i need to use in script component is it FILEGET or FILEGETOBJECT.