Blogs

Making SSIS work with the 64-bit Excel (ACE) provider

I've previously blogged about the challenges of the new 64-bit ACE Provider that includes the Excel driver, since the 32-bit and 64-bit versions cannot be installed side-by-side. In this detailed post that includes screen shots, Hrvoje Piasevoli from...

Posted to Dougbert on SSIS by dougbert on 09-01-2010

Filed under: known issues, Excel, 64-bit

Restarting SSIS packages after failure

Last week while I was on vacation, my Microsoft colleague Steve Howard posted another detailed article on an aspect of SSIS that's frequently misunderstood - restarting SSIS packages after a failure . Steve is often asked to explain and demonstrate...

Posted to Dougbert on SSIS by dougbert on 08-23-2010

Filed under: clustering, high availability

Running multiple SSIS Foreach Loops in parallel

The Parallel Loop Task , recently released in beta by Cozyroc Software , " can execute multiple iterations of the standard Foreach Loop Container concurrently. In tests, a CPU intensive sequential process when executed in parallel on 4-core machine...

Posted to Dougbert on SSIS by dougbert on 08-11-2010

Filed under: third-party products, custom components, vendors

Running PowerShell tasks from an SSIS task

In an earlier blog post , I noted that there hasn't been much buzz about performing SSIS-related tasks with Windows PowerShell. But what if you want to perform PowerShell tasks with SSIS? A PowerShell Task for SSIS was released recently just for this...

Posted to Dougbert on SSIS by dougbert on 08-11-2010

Filed under: third-party products, custom components, vendors, PowerShell

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...

Posted to Dougbert on SSIS by dougbert on 08-10-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...

Posted to Dougbert on SSIS by dougbert on 08-08-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...

Posted to Dougbert on SSIS by dougbert on 08-08-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...

Posted to Dougbert on SSIS by dougbert on 06-26-2010

Filed under: articles

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...

Posted to Dougbert on SSIS by dougbert on 06-16-2010

Filed under: third-party products, CRM, custom components, vendors

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...

Posted to Dougbert on SSIS by dougbert on 06-11-2010

Filed under: known issues, Connect

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...

Posted to Dougbert on SSIS by dougbert on 06-10-2010

Filed under: expressions, Codeplex, tools

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...

Posted to Dougbert on SSIS by dougbert on 06-08-2010

Filed under: Excel, third-party products, custom components, vendors

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...

Posted to Dougbert on SSIS by dougbert on 05-18-2010

Filed under: programming, third-party products, custom components, upgrade

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...

Posted to Dougbert on SSIS by dougbert on 04-23-2010

Filed under: Codeplex, third-party products, custom components, books, vendors, spatial

SSIS and spatial: A new article and some existing custom components

New 3-part walkthrough Today (April 7, 2010), sql-server-performance.com published the 1st of a 3-part series of articles by BI blogger Siddarth Mehta , titled " Geocoding Text-Based Spatial Data for Use In SSIS Packages ." The sample project...

Posted to Dougbert on SSIS by dougbert on 04-07-2010

Filed under: custom components, spatial

Go directly to . . .

Tags

Dougbert Visitors