There's no fixed set of questions, different companies will ask different questions. Memorising questions is not the way to go about preparing for an interview. A good interviewer can tell the difference between someone who knows the area and someone who's memorised answers.
Don't exaggerate your skills.
Don't be afraid to say "I don't know", but always have a plan for finding out.
Believe it or not, that is how some interviews are cracked and after that, the person learns on the job. I have also seen cases where people get help from their "ssis/anything" expert friends, for thorny issues in development if forums and google cannot provide the answers. After they gain 2-3 years of experience themselves, they are set to sail (mostly) on their own.
I agree that one must not memorize questions. But, its still good to see some interview questions as if they exercises for you to solve. The more issues and problems you see, the more you learn.