Avg_fragmentation_in_percent is not high, so the index is not fragmented. Have you tried looking at the execution plan of the query?

goodluck (2/2/2012)

---

Please let me know if once the data is inserted into Partitioned table and we build index on the partition in which the data got inserted. Do we need...

What is the values you see when you run the DMV sys.dm_db_index_physical_stats against that partition alone..

There should be some kind of security involved in SSIS packages where there is sensitive data (passwords or login info)..

Read these resources and they might help you..

http://msdn.microsoft.com/en-us/library/ms141747.aspx

http://msdn.microsoft.com/en-us/library/ms137833.aspx

Well, if there requirements need you to record what's moved on what date and time, you will have to come up with SSIS packages (Replication can't do that), along with...

If you set that up, every time the package needs to be executed, it has to have that login credentials and it will eventually missed.

I would suggest you have...

I second Jared's thoughts

You may also have to click Edit Mappings and choose one of the following....

Delete the existing data in the destination table and insert the new data OR

Append rows to...

something like this..

LTRIM(RTRIM(Parameters!time.Label)

Yes..

How are you storing the security credentials for the login.

What is the package protection level set to?

I guess that... I was checking what's the OP is doing. Will have to wait for the OP's response..

No worries. You are welcome..

This is just an idea, have you tried trimming the leading and trailing spaces using LTRIM or RTRIM ?

You mean, you create SSIS package afresh in BIDS every time? Are you sure you have necessary permissions on the folder location (most commonly the local drive) where you are...