About
I’m John Welch, a BI Architect with Varigence. Varigence builds tools and frameworks that enable the creation and management of end-to-end business intelligence solutions with unprecedented ease and speed. I’ve been working with business intelligence and data warehousing technologies for 9 years, with a focus on Microsoft products in heterogeneous environments. I’m a Microsoft Most Valued Professional (MVP), and an experienced speaker, having given presentations at Professional Association for SQL Server (PASS) conferences, the Microsoft Business Intelligence conference, Software Development West (SD West), Software Management Conference (ASM/SM), and others. He has also contributed to three books on SQL Server 2008, “Microsoft SQL Server 2008 Management and Administration”, “Smart Business Intelligence Solutions with Microsoft SQL Server 2008″, and “SQL Server MVP Deep Dives”.
I work on a couple of open source projects that help ease the development process for Microsoft BI developers. One is BIDS Helper, an add-in for Business Intelligence Development Studio that adds commonly needed functionality to the environment. I also am the lead developer on ssisUnit, a unit testing framework for SSIS.
Your article on interfacing with AD using SSIS is exactly what I needed so thanks for that.
In that article (Retrieving Information from Active Directory with SSIS) it mentions an attached package containing both approaches that you tried. However, I’m unable to find any download link and was wondering if I’m just missing it or if the package is no longer available.
Thanks again and thanks in advance for your reply.
Tom
Tom, glad you found it useful. I’ve updated the post with a new link to the sample package.
John, Thanks for your sharing your expertise. The articles about parent-child inserting are helpful to me, as I am currently doing a similar process using stored procedures. I’m curious if there would be any performance gains in using SSIS instead, as you illustrated in your sample packages. Please email me if you have time for a quick question. Thanks! Richard
John,
I would like more info on the presentation you did at Charlotte Code Camp on automating SSIS.
Is there a way to code generate SSIS script if importing many tables that are similar? I am currently using Entity Framework to import data to the warehouse, but it is way too slow. I assume SSIS will speed this up, but I have some complex mapping during import that further normalizes the data.
Dave
Yes, I recently did a blog on how you can do this using BIDS Helper and Biml. That’s probably the simplest approach.