May be this is not such a good idea but I would like to give it a try. I guess there is no harm in trying it. I try to answer Stack Overflow questions tagged under ssis. If I don't know about what questioner is asking, then I try out an example to learn more about it before providing a workable solution. It also helps me to learn about the technology by trying to answer them. It got me thinking what if I revisited all the questions under that tag and try to answer them as much as I can. So, I copied all the questions under ssis into a
Google docs spreadsheet. At the time of writing this question, there were
I intend to do the following. I would like to know if I am doing anything that is unwelcome in Stack Overflow community.
I noticed that lots of the titles and descriptions are poorly phrased. So, I would like to rephrase them and correct the grammatical/spelling errors. Remove the technology prefixes like most questions are prefixed with
SSIS/SQL Server:. Remove the salutations.
If a question is more like an error or a problem, I would like to give it a try by solving them. It will help me to learn something out of it and also contribute to the community, I hope.
If the questions have not been answered, I will try to provide an answer provided I can come up with one.
If those questions already have accepted answers, I would like to blog about it on my website at least for my future reference. Is it wrong to mention in my blog, that the post is an answer to a Stack Overflow question along with a link to actual question?
I usually post answers directly at Stack Overflow but except in very rare cases where my answer is too long. I describe the answer at Stack Overflow as much as I can before providing a link to the blog.
EDIT: I have decided to post the complete answer in Stack Overflow unless and until I exceed 30,000 characters, which I highly doubt that I will.I know there is nofollow attribute on Stack Overflow links, so I am not trying to gain anything by linking to my blog I want to make sure that I don't violate any copyrights or ethics of the community. Even if the question has an accepted answer, should I provide an answer of how I went about solving it (only if it differs from accepted version)?
If I come across with questions that are very similar. How do I group them? Should I post an answer/comment saying that this question is also related to so and so questions?
Some questions refer to SSIS 2005 (older version), in which some things the questioner was trying to do may not have been feasible. If I found a viable solution in the newer versions, should I post it as an answer?
Most probably along the way, I will come across interesting questions/answers that I can upvote. I would like to keep the questions under the ssis cleaner and more helpful to others who might come across them in future.
I couldn't find a way to easily export the questions. So, I visited each page, copied the questions along with links (so I can easily visit from spreadsheet) and pasted them in the spreadsheet. It took about 3 hours. If there is an easier way, please let me know.
I would really appreciate your inputs.