Using a money-transfer credit card can affect your credit rating in the same way as any other credit card. If you are late with repayments or miss them completely, this can leave a mark on your credit file and negatively affect your credit score. Missing a payment can also result in you losing your 0% offer.
On the flipside, however, if you use your money-transfer card sensibly and make your repayments on time, this can have a positive effect on your credit score and show lenders you are a responsible borrower.