"Execute Process Task" is the best choise upto me..

very Useful for the Beginner, something like a spoon feeding Clear Explanation about "What is SSIS"..

Thanks,

Prabhu

yahoo... !!!

its rocking.. thanks man.. working fine..

Thanks,

Prabhu

Hi Jeff,

you have to start SSMS a little differently. I keep an icon on my desktop to start SSMS. If hold down the {Shift} key and right click on the...

Thanks Grant...

Hi Grant,

Happy to see you in my post, my requirement is simple, just need to pull down the changes happens with the rows and to dump into someother history table....

Hi Anthony,

Thanks for the link, I would like to include myself in the NewBie List.

Thanks,

Prabhu

@ Paul & Sankar,

Hi,

My appologize for Replying for a Outdated Post, but I think this might be Useful for the Newbie from this point.

please have the Example of Changing...

Those are NOT NOT NOT "best practices".

The best practice is to carefully and accurately select the best clustering key for each table based on that specific table's needs, not to...

What Grant is willing to say is, hlsc1983 should get how to design...

Let Me Assume like

Acronyms Used as below, your's...

so the Conclusion is:

Avoiding the KeyLookup (excluding from the Query Plan/Execution Plan) is depends on the Percentage it occupies the latency of performance.

If it has a low importance and low...

Hi Gila,

I don't know why both of our thought are synching for most of the time, I too feel the...

I agree...

== Correction:

--------------

what I did is, I created a Non-Clustered (Non-Unique) index on Column2