We have a couple of in-house servers running Jitterbit along side SQL Server 2008 R2 and was wondering if anyone has had any dealing with Jitterbit and whether it's comparible to SSIS? i.e. can I sack Jitterbit in favour of SSIS?
This reply is a bit late. You haven't provided too much details what you are using Jitterbit for? Is there a specific functionality you use and what is it?
In general I think Jitterbit is too limited based on what I have seen so far. It might be useful for some simple integration scenarios, but once you try to implement more complicated integrations you will hit brick wall.
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/