"I currently just mark .dtsx files as binary in .gitattributes and then commit them as a file."

How do get a branch made for them? We use Bitbucket with Sourcetree, it would be great if we could manage these projects by way of Redgate->Git->Bitbucket->SQL Server

I currently just mark .dtsx files as binary in .gitattributes and then commit them as a file.

It would be almost impossible to meaningfully compare two revisions of an SSIS package, so I'm not sure what support for SSIS would actually do.

If you're using SVN for your repository, have a look at VisualSVN http://www.visualsvn.com/

It would be nice to be able to use the DB compare tools to promote/compare/copy SSRS/SSIS as well

SSIS uses the visual studio shell as well as .sln files. I haven't tested this, but have you tried the Team Foundation Server MSSCCI Provider 2010?

http://visualstudiogallery.msdn.microsoft.com/bce06506-be38-47a1-9f29-d3937d3d88d6/

Could you explain what you mean by this?

I have SSIS in version control already but it's ugly since auto-generated XML files don't have very good conversioning support.

However I'm not sure how you could do it better?