SimonCa:
Hello
Hello there. My recommendation is to not tinker with power mains electricity components if you don't really know what you're doing. In your case, you not only didn't know what you were doing, but you also went ahead with just connecting something together (with no understanding of it).
JohnRob is right. The transformer you have converts AC power mains voltage to a smaller AC voltage, for powering lights that work with an applied 12 volt AC voltage. Not DC.
What you need to use is a regulated DC power supply, such as a 9 volt DC power supply. This means..... don't use that transformer. Use something appropriate...... which will be a 220 volt AC to a DC voltage converter device.