SSIS or CLR-Integration
Posted on 2013-01-09
can somebody explain the fundamental differences between SQL-Server SSIS and CLR-Integration technologies, maybe both in architectual and technical way for SQL-Server 2008R2.
Which Technology should be use for what kind of problems?
My concrete Problem is to generate and store some PDF-Files (with the support from a third-party .NET-Assembly) from Data stored in the SQL-Server. Which of the upper technologies would be better to solve this problem and why?