Thanks for all valuable suggestions

Actually i like Rowversion Datatype option.Is it a new datatype in SQL(Couldn't find it from SSMS).The way i understand, it's almost similar to Timestamp

P.S: We...

Thanks....that was good info

Damn...It's the permission issue(proxy account doesn't have permission to access the network drive)

Yes i can see the file....

I created a proxy account and ran the job using proxy account (Couldn't change the sql server agent service account to domain acct, so created a new proxy account) but...

Silly mistake.. Forgot to change the Operation in File System Task to Rename File(It was move file before)

Not sure whether it's a casting issue...I was able to evaluate the expression without any problems

Ran package under 32 bit mode, didn't work....Any other suggestions???

I am executing package from the server where ACE drivers are installed

Coalesce is something which doesn't give me the desired results....All i am trying to do is, if the parameter is not passed from UI i need to remove the parameter...

Thanks...I created indexes and tried to observer Reads, Writes, CPU and Duration for some of Stored procedure(using Profiler)

After creating indexes Reads, CPU decreased considerably where as Duration increased. Isn't it...

Thanks for the info...

While analysing execution plan i noticed something called Estimated Number of Execution...what does it mean??

I know creating too many indexes on a table are harmful....How do we...

Thanks for your good explanation....I was just playing around without using include statement while creating a non clustered index(analysed the execution plan), it give's a RID Lookup for

Address,...

They are in primary filegroups

Yes it does have header excel sheet. Also i m running the package in a 32 bit machine but i did set the runtime to 64 bit

Thanks