• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 974
  • Last Modified:

SSIS or CLR-Integration

Hello,

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?

kind regards
0
knoggly
Asked:
knoggly
  • 2
4 Solutions
 
Éric MoreauSenior .Net ConsultantCommented:
you can use CLR integration to provide features to SQL that it doesn't have. You can check http://emoreau.com/Entries/Articles/2011/05/Creating-SQL-Stored-Procedures-in-Net-SQL-CLR-Integration.aspx

About generating PDFs, personally I wouldn't create a job using CLR-integration. I would simply create an application creating the PDFs. If you don't already use a library to generate PDFs, I suggest that you look at http://www.aspose.com/.net/pdf-component.aspx
0
 
LIONKINGCommented:
As to complement emoreau's response... SSIS on the other hand provides a way to import/export data from and to SQL Server.

SSIS also provides the ability to manipulate the data "on the fly", besides a lot more features that could be used depending on your scenario. SSIS is pretty flexible when it comes to the data sources, transformations and data destinations available; and it also gives you the ability to run scripts (C# or VB.Net) which improves the possibilities.

You can read more about SSIS in this link
0
 
Goodangel MatopeSoftware ArchitectCommented:
For creating PDFs, have you considered using SQL Server Reporting Services? Check this out:

http://www.codeproject.com/Articles/15555/Generating-PDF-reports-programmatically-using-SQL
0
 
Goodangel MatopeSoftware ArchitectCommented:
You can also check out this link by the same author which provides an alternative to SSRS, which is the report viewer control

http://blog.rptea.com/post/Create-PDF-via-SQL-Server-Reporting-Service-or-Report-Viewer-Control.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now