Thank you rVadim .The solution works

It is the destination that is causing the problem. I posted this on microsoft forum and got the answer.

https://social.technet.microsoft.com/Forums/sqlserver/en-US/cdd9bc88-ffa9-4ff8-84a9-022a5f9bdffa/ssis-package-hangs-randomly-on-different-tasks-when-scheduled?forum=sqldatawarehousing

That's what I am forced to do.I wish Lookup could handle that.We cannot use variable in Lookup transformation.

Will also try with LOOKUP PLUS from Codeplex.

The store records have different effectivefrom and EffecttiveTodate. I ahve to load data that matches both the records in my facts.So if the user selects date that is within the...

Its not like that .I mean If I have to write a Stored Procedure in Oracle that is already written in SQL Server .Taking into consideration that same tables exist...

Thank you Very much .I got it. I am in SQL Server 2005.

Thanks for your reply.But the 1st query gives me an error in Adventure Works DB:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'sys.sql_expression_dependencies'.

So I tried to see if...

In fact,my other friend also attended the same interview. For him instead of Hoursworked. He gave him SUM(Amount) as agggregate.

So in Such case aslo How can you avoid EmployeeName in...

Well I used the format property. I didnt know abt the export to excel constraint.I will use format property henceforth.

thank you

THANK YOU ALL. I got a method. I did not change or add an expression but,in the format properties of the text box I used "#,##;(#,##0)" (without the quotes) and...