Making SSIS work with the 64-bit Excel (ACE) provider
Published 1 September 10 11:50 AM | dougbert
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...
Filed under: , ,
Restarting SSIS packages after failure
Published 23 August 10 1:52 PM | dougbert
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...
Filed under: ,
Running multiple SSIS Foreach Loops in parallel
Published 11 August 10 11:0 AM | dougbert
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...
Filed under: , ,
Running PowerShell tasks from an SSIS task
Published 11 August 10 10:39 AM | dougbert
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...
Filed under: , , ,
Loading Active Directory data with SSIS
Published 10 August 10 7:3 AM | dougbert
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...
How to follow a German SSIS blog in English
Published 8 August 10 6:1 PM | dougbert
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...
New ETL framework (beta of version 1.0) released on Codeplex
Published 8 August 10 5:49 PM | dougbert
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...
Using SSIS to republish SSRS reports in bulk
Published 26 June 10 7:35 AM | dougbert
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...
Filed under:
SSIS with Dynamics CRM: Case study from a large bank
Published 16 June 10 9:46 AM | dougbert
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...
Filed under: , , ,
Top Connect issues recently for SSIS
Published 11 June 10 2:47 PM | dougbert
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...
Filed under: ,
Wow, an SSIS Expression Tester tool
Published 10 June 10 1:28 PM | dougbert
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...
Filed under: , ,
New Excel components out in beta from Cozyroc
Published 8 June 10 3:41 PM | dougbert
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...
Filed under: , , ,
Installing a new version of an SSIS custom component
Published 18 May 10 12:54 PM | dougbert
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...
Filed under: , , ,
More SSIS and spatial, with an offer from SAFE Software
Published 23 April 10 1:26 PM | dougbert
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...
Filed under: , , , , ,
SSIS and spatial: A new article and some existing custom components
Published 7 April 10 1:58 PM | dougbert
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...
Filed under: ,
More Posts Next page »