Freinds,

Finally the confusion has got endup and based on the advice from you guys (bit from each of you) have achieved the query to run faster and completed in...

@Erikur,

Further on this, the pagination is only going to kick in after these three right-most operators and the sort, all the work repeated for each page, hence the suggestion...

@Grant,

yeah, I am also in your side, the business logic is to exclude that filter condition in start and end dates or any one has not provided. so I have...

Hooovv !! its a good tips boss, I would have a look at it and let you know shortly.. thanks a lot

Friends,

this is bit urgent and I would feel very greatful if I get any immediate replies.

thanks in advance.

Prabhu.st

Thanks Koen & Phil,

your values suggestions worked..

Thanks,

Prabhu

Try out a Execute SQL Task with the following code

create table #temp (cust_id int,phone_type varchar(10),phone_number int)

insert into #temp values(10001,'Home',1234),(10001,'Business',5678),(10001,'Mobile',918239)

selectcust_id,

max((case when phone_type='Home' then phone_number else 0 end)) as home_phone,

max((case when...

in the advanced tab, the datatype is set to Unicode dt_stwr (something which is equivalent to nvarchar) and the width is 4000, actual data flows through the flat file is...

It is a Tab delimited columns

may be this link would helpful for you

http://stackoverflow.com/questions/16986756/cannot-initialize-the-data-source-object-of-ole-db-provider-microsoft-ace-oledb

Hi Livingston,

thanks for your reply, but since it was little bit urgent, i fixed it manualy.

anyway, 4th week's saturday of Each april from the year (calendar year) 2006 is the...

Gail,

to be simple, all I need is to calculate the fiscal week. on a fiscal year.

start day of a week is saturday and ends on Friday.

the query i got is...

John,

I will do the correction you suggested, thanks.

Jack.

the answer which you gave me is what I expected, thank you so such..

-Prabhu

yes, that is the solution I too thought, and make sure you give "Operation"="move" in the file system task editor and overwrite destination set to true.

Thanks,

Prabhu

your question is not clear,

I can understand two questions.

How can I view / why my files are not visible once it is processed from the package. ?

How can I...