Microsoft SQL Server Integration Services (SSIS) – anyone using it?

[CaribbeanPirate]

I have got some time on my hands so I am researching things for an application I run. Our batch processes are a bit of a dog’s dinner of scheduled bat files. Setting things up under SSIS that comes with SQL Server 2005 looks like a good idea on the face of it.

Has anyone got any experience of using it in anger?

 

[CaribbeanPirate]

Obviously not! This worries me. I don’t want to be suckered into committing to it without learning from other peoples experience.

All there is on the net is smart-arses telling me trick on how to do this and that; but no reports on proper live usage.