Aug
10
2010

Loading Active Directory data with SSIS

Steve Howard - the same guy who previously provided detailed clustering advice on this blog - has posted an article that includes 3 different approaches for retrieving Active Directory information in an SSIS package. The article includes screen shots and code samples. As Steve explained to me, "Bits and pieces are available on the internet, but nothing to really put it all together to allow someone to see how to do it." Processing Active Directory Information in SSIS Steve works for Microsoft Se... [More]
Aug
8
2010

How to follow a German SSIS blog in English

Did you know that there's an active SSIS blog in German by Tillman Eitelberg from Bonn in Germany? You can read it in [imperfect] English by using the Microsoft translator in your browser. First, here's the blog: http://ssis-components.net/ The Microsoft translator will open the German page side-by-side with a page where it provides the [imperfect] English translation, like this: And how to you accomplish this? If you have the Windows Live toolbar installed (search for "download Windows Live Essentials"), ... [More]
Aug
8
2010

New ETL framework (beta of version 1.0) released on Codeplex

SSIS consultant and blogger James Beresford ("BI Monkey") of Sydney, Australia has released the beta of version 1.0 of an ETL Framework on Codeplex, described as "an ETL Execution, Control and Logging system for ETL projects using SSIS." James' blog post announcing the new framework: http://www.bimonkey.com/2010/08/ssis-etl-framework-v1-goes-beta/ BI Monkey SSIS ETL Framework on Codeplex: http://ssisetlframework.codeplex.com/ -Doug  
Jun
26
2010

Using SSIS to republish SSRS reports in bulk

MSDN has recently published an article that explains how to update parameterized SQL Server Reporting Services (SSRS) reports in bulk by using a SQL Server Integration Services (SSIS) package. The article, Bulk Report Generation using SSIS and SSRS 2008 R2, was written for MSDN by By Siddharth Mehta, Senior Technical Consultant for Business Information Management unit at Capgemini India Private Limited (Mumbai branch). You can read Siddharth Mehta’s blog about Microsoft BI at http://siddhumehta.blogs... [More]
Jun
16
2010

SSIS with Dynamics CRM: Case study from a large bank

Two years ago, I wrote a short blog post here about using SQL Server Integration Services (SSIS) with Microsoft Dynamics CRM. There are 2 ways that you can work with CRM programmatically: The supported way, through the Web services API that the application exposes The, uh, less supported way, by interacting directly with the database where CRM stores its data And we've got some information for you today on both approaches! First, our feature article, "Uses for SSIS with MSCRM In a Bankin... [More]
Jun
11
2010

Top Connect issues recently for SSIS

This afternoon I was testing to see whether I had VSTS installed correctly, and I clicked on one of my saved queries for Microsoft Connect items related to Integration Services. Whoa! People are NOT happy about the incompatibility with Visual Studio 2010 that Jeff Bernhardt recently addressed on the team blog! In fact, it looks like there were 97 things that people haven't been happy about in the last 90 days. Here are those 97 things, sorted in descending order by number of votes. I was going to ... [More]
Jun
10
2010

Wow, an SSIS Expression Tester tool

Darren Green of SQLIS.com has posted a new SSIS Expression Tester on Codeplex: http://expressioneditor.codeplex.com/ See the SQLIS blog post from yesterday (6/9/10): http://www.sqlis.com/sqlis/post/ssis-expression-editor-tool.aspx German-language blog post from Tillman Eitelberg at ssis-components.net: http://ssis-components.net/post/2010/06/09/Expression-Tester-Tool.aspx Crank this up along with your expressions Cheat Sheet from PragmaticWorks and the tools for expressions in BIDS Helper, and reduce t... [More]
Jun
8
2010

New Excel components out in beta from Cozyroc

Yesterday (6/7/2010), Ivan Peev of Cozyroc announced the beta release of version 1.5 of SSIS+, Cozyroc's suite of custom components for SQL Server Integration Services. The new components for Excel in SSIS caught my attention. The announcement summarizes this new release as follows: "The new version includes components for integration with Microsoft Dynamics CRM, enhanced tasks and connections for handling emails, enhanced support of Microsoft Excel workbook files and components for integration wi... [More]
May
18
2010

Installing a new version of an SSIS custom component

Recently a friend asked for help with the, uh, challenges of cleanly installing a new version or build of a custom component for SQL Server Integration Services (SSIS). Here are the steps: Close BIDS or Visual Studio. Uninstall the old version of the component. Install the new version of the component, including the following steps: Copy the main assembly to the appropriate component folder under the 32-bit Program Files folder. Copy the main assembly to the appropriate component folder under the 6... [More]
Apr
23
2010

More SSIS and spatial, with an offer from SAFE Software

An offer from SAFE software, "The Spatial ETL Experts" In my recent blog post where I mentioned some components and resources for using SSIS with geospatial data, naturally I mentioned the extensive set of custom components available from SAFE Software. I pointed out that their SSIS integration is only available as part of larger product packages. SAFE contacted me after that blog post, and invited me to share this offer of an extended free evaluation period with SSIS developers: "Developer... [More]