Dec 14 webinar - Loading Spatial Data into SQL Server with FME

I have mentioned SAFE Software before as the most visible provider of tools and components for working with spatial data in Microsoft SQL Server, with or without Integration Services. SAFE recently announced a free 1-hour Webinar on Tuesday, December 14, 2010 - "Loading Spatial Data into SQL Server with FME". More information: Sign up for the Webinar Read more about SAFE Software and SQL Server Here is the description of the Webinar from their Web site: "This free webinar demonstrat... [More]

More affordable spatial data loading for SQL Server

Do you have spatial data stored in ESRI Shapefiles, MapInfo TAB files, MIF/MID files, or CSV files that you have to load into SQL Server? If you do, then this new and more affordable product from SAFE Software may meet your needs. SAFE has quietly released FME Desktop SQL Server Loader Edition, a $500 subset of the full functionality found in their "FME Desktop Microsoft SQL Server Edition" product. Here's the description of this new product from their Web page: "Quickly load data into ... [More]

Data profiling for SSIS with plug-in rules of your own

Tillman Eitelberg has blogged a sneak preview with screen shots of his company's new datenfabrik.profiler, which will run as a component in the data flow of a SQL Server Integration Services (SSIS) package. Till will present the beta version of the component within a few days at SQLBits 7 in York, England. There is not a download available at the present time. One of the most interesting features is that the final version will expose a plug-in architecture that lets you "plug in " additional ... [More]

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]

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]

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]

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]

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]

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]

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]