Komponenten

Die folgenden SSIS Komponenten sind von mir in den letzten Jahren entwickelt worden und sind bei Codeplex unter der Microsoft Public License (Ms-PL) veröffentlicht worden.
Bei Fragen, Fehlern, Hinweisen oder sonstigen Diskussionsbedarf zu den jeweiligen Komponenten, nutzt bitte die entsprechenden Seiten in den jeweiligen Codeplex Projekten.

DomainValueDestination

SSIS DQS Domain Value Import

This component provides capabilities to import domain values including synonyms into an existing knowledge base. The intention of the component is to help you automate you DQ Projects and provide more efficient ways to maintain Knowledge Bases (KB).

https://domainvalueimport.codeplex.com/

DQSPublishSSIS DQS Matching Transformation

In addition to the SSIS DQS Domain Value Import Data Flow component, the Publish DQS Knowledge Base Task belongs to the Project. The task allows you to publish a knowledge base, which is in status domain Management.

https://domainvalueimport.codeplex.com/


dqs_matcing_ico

SSIS DQS Matching Transformation

The SSIS DQS Matching Transformation uses Data Quality Services (DQS) to find duplicate data within the SSIS data flow.

The SSIS DQS matching component is developed and tested for SQL Server 2012 with DQS assembly version 11.0.3000.0. We try to support future versions of DQS and SQL Server. However, we cannot guarantee that the component will work with all future versions of DQS.

http://ssisdqsmatching.codeplex.com


SSISGoogleAnalyticsSource_thumb.png
SSIS GoogleAnalyticsSource

A SSIS Data Source Component for SQL Server 2008 and SQL Server 2012 to load data from the Google Data API.

Functions:

  • Load data from your Google Analytics Profile
  • Define different Metrics and Dimensions
  • Custom variables can be selected
  • Set Metrics and Dimensions Filter
  • Set Advanced Segments

http://analyticssource.codeplex.com/


SSISReportGeneratortask.png
SSIS ReportGeneratorTask

SSIS Task for SQL Server 2008 and 2012 to create server reports or local reports from a recordset data source.

Functions:

  • Render local reports (recordset)
  • Render remote reports (SQL Server Reporting Services 2008 and 2012)
  • Render remote reports from SharePoint 2010
  • Render remote reports from SQL Azure Reporting
  • Reports can save with date and time as prefix
  • Render reports in different formats
  • Show reports during execution
  • Generate snapshots
  • View server report properties during configuration
  • Set report parameter via SSIS variables

http://reportgeneratortask.codeplex.com/


SSISShapeFileSource.png
SSIS ShapeFileSource

SSIS ShapeFileSource imports ESRI Shapefiles, and the associated attribute file (.dbf). The component based on the free Shapefile C Library. Current version 1.0 beta can import ShapeFiles with Point, Linestring, Polygon and Multipolygon as SqlGeometry.
The version has been tested with several country level spatial data from http://www.diva-gis.org/Data, NUTS (Eurostats Administrative/Statistical Units) and some OpenStreetMap.

http://shapefilesource.codeplex.com/


SSISSMSTask_thumb.png
SSIS SMS Task

SSIS Task to send SMS (Short Message Service) over a SMS Gateway per HTTP/HTTPS.
This task sends SMS instead of the inbuilt email task, jabber (http://www.cozyroc.com/ssis/jabber-task) or twitter (http://www.codeplex.com/SSISTwitterSuite) in Microsoft SQL Server Integration Services 2008.

http://smstask.codeplex.com/


SSISImageSource.png
SSIS ImageSource

SSIS ImageSource imports images as blob with various additional information such as EXIF data, GPS data, file information, etc. The ImageLibrary from the project Dot Net Library is used.

  • The project Dot Net Library is used to read the various information
  • Retrieve the Exif Tags from an image
  • Retrieve the GPS data from geo-tagged photographs
  • Retireve the File Information from an image
  • Load images as binary data (DT_IMAGE) into the dataflow.

http://imagesource.codeplex.com/

Leave a Reply