Thanks for reply, but in car table data is same pattern as I wrote. Yes model_id is repeated.

Thanks michale it works now.

Thank you it works now

No it is not hw

Michael, I did try following way but still showing error before running. this is what I was looking for

DECLARE @VALUE INT

SET @VALUE = 101

SELECT

STATEUS

from

STATEOFUSA

WHERE STATEUS =

(case

when @VALUE = 103

then...

yes I do have to use case

Great. Thanks for your help

Yes, I got it that part and it does work too. If you know, could you please tell me if location is different then how to point that dtsconfig to...

Thank you. If I put both dtsx and dtsconfig file together in different computer then when I execute package it will aumotmatically point the path correct.

Sir that was sample of table, it not real table. If I solve this problem, then I can easily do my real problem.

Thank you Sean Lange. I will try using user define function.

create table dbo.EmployeeWork

(

empid int,

CountryWorkAt Varchar(20)

);

insert into dbo.EmployeeWork values (1,'China');

insert into dbo.EmployeeWork values (1,'Germany');

insert into dbo.EmployeeWork values(1,'USA');

insert into dbo.EmployeeWork values(2,'China');

insert into dbo.EmployeeWork values(3,'India');

insert into dbo.EmployeeWork values(3,'USA');

insert into dbo.EmployeeWork values(4,'China');

insert into dbo.EmployeeWork...

with out .sou, and bin folder also, QA team can executer that package

Main purpose of that package to be in SVN is so that it can be executed by QA and Production team too. In that senerio I have to upload all...

I did try that way but it still throwing an error.