Tools and Components for Microsoft's SQL Server Integration Services

View previous topic View next topic Go down

Tools and Components for Microsoft's SQL Server Integration Services

Post  Todd McDermid on Fri Feb 06, 2009 2:44 pm

I am coordinating the SSIS Community Tasks and Components project over at CodePlex that is intended to catalog third-party add-ins and tools for Microsoft's extensible ETL product.


The focus of the project is to highlight the open-source tools that are available - in order to provide a good library of resources for those of us that may want to extend SSIS's capabilities. The project also provides a brief listing of free (but not open-source) and commercially available tools for SSIS. There are currently over 30 Connection Managers, Tasks, Sources, Transforms, and Destinations catalogued.

  • If you are a user of SSIS, you may find some tools that can replace complex hand-built collections of Data Flow transforms with one step.
  • If you know of some tools for SSIS, please leave a comment on the project so I can add it to the catalog.
  • If you are looking to perform something in SSIS that doesn't currently seem possible, even after reviewing the tools on the site, code your own using the examples provided.


I, for one, was disappointed by Microsoft's less than stellar "SCD Wizard" component in Integration Services, so I used some of the resources now shown in this project to help me code my own open-source alternative. (And as stated by the Moderator - that component is NOT endorsed, recommended, or approved by the Kimball Group!)
avatar
Todd McDermid

Posts : 11
Join date : 2009-02-04
Location : Nanaimo, BC

View user profile http://toddmcdermid.blogspot.com

Back to top Go down

Re: Tools and Components for Microsoft's SQL Server Integration Services

Post  robber on Sun Mar 01, 2009 11:01 am

Here is a link for a tool that allows you to comprehensively log a DTS/SSIS package:
http://www.codeplex.com/DTLoggedExec

One of my biggest gripes with respect to the Microsoft BI platform is the lack of a comprensive metadata architecture. Here is a link for an application that tries to overcome some of those short comings:
http://metashare.sourceforge.net/

Rob

robber

Posts : 41
Join date : 2009-02-28
Location : Canada

View user profile

Back to top Go down

Re: Tools and Components for Microsoft's SQL Server Integration Services

Post  donnaj8887 on Thu Aug 19, 2010 6:15 am

robber wrote:Here is a link for a tool that allows you to comprehensively log a DTS/SSIS package:
http://www.codeplex.com/DTLoggedExec

One of my biggest gripes with respect to the Microsoft BI platform is the lack of a comprensive metadata architecture. Here is a link for an application that tries to overcome some of those short comings:
http://metashare.sourceforge.net/

Rob

Such a very amazing link!
Thanks you for the post.


__________________
Watch The Switch Online Free

donnaj8887

Posts : 1
Join date : 2010-08-19

View user profile

Back to top Go down

Re: Tools and Components for Microsoft's SQL Server Integration Services

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum