Sep
12
2010

API reference for built-in SSIS data flow components

Developers who want to create and update SSIS packages programmatically often wonder, "Where the heck is the API reference for all the built-in data flow sources, transformations, and destinations?" The short answer is: There isn't any. Why not? Because - at least at design time - an individual data flow component does not have any properties or public methods that are unique. A data flow component has only the properties and methods that it inherits from the base class, PipelineCompone... [More]
Aug
11
2010

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 was executed 3 times faster compared to the sequential." This new task appears in Beta 2 of the Cozyroc package, SSIS+ 1.5. For more information or to try out the Parallel Loop Task... Read the blog post announcing the new task and the new Beta 2 relea... [More]
Aug
11
2010

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 purpose by /n Software. From their Web site: "The PowerShell SSIS Task is the 'swiss army knife' of SQL Server automation. It can be used to create highly-flexible SQL Server workflow solutions via easily configurable PowerShell scripts. When ... [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
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]
Apr
7
2010

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 combines the use of SSIS with the Bing Maps API and Web service. Anything else out there? It's not easy to find more information about using SQL Server Integration Services (SSIS) with spatial data! If you search for "SSIS + mapping," of course you find dozens of posts a... [More]
Nov
9
2009

Updated component: Refresh SSRS reports directly from an SSIS package

My German's a little rusty, but I still try to follow the German-language SSIS blog by Tillman Eitelberg of Bonn, Germany. In yesterday's posting, he talks about his Report Generator Task project on Codeplex (in English). Many of you have probably discovered this custom task already on your own. The Report Generator task lets you load and transform a data set in your SSIS package, then regenerate a (pre-existing) SSRS report with that data. You can save the report output in Excel or PDF format, and... [More]
Apr
28
2009

HTML Table Destination: An (incomplete) SSIS custom data flow component

I had fun recently creating a custom data flow destination for Integration Services - an HTML Table Destination that writes out the data from the data flow to an HTML file as an HTML table. No applause, please - I copied SSIS developer Matt Masson's code from Codeplex to get started, including his handy helper functions for the tedious stuff like adding custom properties and caching input columns. Plus, it's not rocket science to output tabular data to a well-known text-based markup format. You too could be... [More]