It is nice way to learn new things.Thanks Andy.

Can you please provide more inputs on the same.

1. What is your SP doing.

2. If possible, please provide SP script.

3. Your question with expected resultset.

Thanks for question Steve.

Learnt new thing today.

Thanks for kind replies.

Well when I contributed this question, till then it was not published but later Steve's same QotD published first and it became a revision QotD.Even i posted...

Just curious to know why did you design your package like this ?

I meant you could have used a DFT and then an OLEDB source and destination with bulk insert.There...

Thanks for question.

Thanks for question Steve.

Nice question with nice explanation.Thanks Andy for question.

tnhope (6/1/2014)

---

I need to create a view called High_Score of Teams that scored more than

40 points (in home and away games), grouped by country.

something along these lines, I am guessing.

create...

Please have a look on below articles from Orlando.

Using the Konesans File Watcher Task in SSIS to Process Data Files[/url]

Using the WMI Event Watcher Task in SSIS to Process Data...

Thanks Hardik for question.

However with the introduction of new keyboard having fn key in place.Microsoft should also change their doumentation.

As here it would be (fn + f6) key would...

Thanks for question Steve.

Thanks for quetion Richard.It was nice to learn new thing.Have never used it.

Can you please post DDL and few sample records for two tables ?

Just do a cross tab.