Thanks- Yes, the indexes on the partitioned table are aligned and they serve the partitioning strategy.

Thanks for the replies all of you...

How do we align indexes and how different is it from rebuilding indexes?

also does having a row_overflow_Data in the allocation unit when running the...

Because, the partition table is very slow as though no indexes were built on it. When I ran the sys.dm_db_index_physical_stats on the table, I figured there was a ROW_OVERFLOW_DATA entry....

yes. It uses index seek..

Thanks for the reply.

here are the statistics

index_type_descavg_fragmentation_in_percentfragment_countavg_fragment_size_in_pagespage_count

CLUSTERED INDEX0515706.784314291046

NONCLUSTERED INDEX0.01539053554240.648148112995

NONCLUSTERED INDEX0.0385505015518.82594

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 to...

hey Todd,

Your process helped me a lot to send the result set to send mail task.

But I get the result set in xml format in the message body. The...

Thanks for the replies.

But is there a way I can get the mappings for the source and destination columns or dataflow task. I just have NATIVE SQL OLEBD connections.

Thanks...