Nov
6
2010

Webcast: Unlock the spatial data stored in Microsoft SQL Server

(I received this invitation at Microsoft, and was encouraged to invite my "customers and partners." First, take a look at this output from the DataConnector to whet your appetite...) Understanding Web Mapping and Data Visualization using DataConnector Attend this webcast and learn how SQL Server 2008 can help you visualize your data on a map using a free download called DataConnector. You’re most likely already familiar with SQL Server support for spatial data and now with DataConnector ... [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]
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]
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]
Feb
10
2009

Add helpful package design tools to BIDS: A Codeplex project focus

Among the gems on found on Codeplex, "Microsoft's open source project hosting web site", BIDS Helper stands tall. BIDS Helper is "a Visual Studio.Net add-in with features that extend and enhance the functionality of Business Intelligence Development Studio (BIDS)." It supports SQL Server 2005 and 2008. It includes helpful tools for Analysis Services (22), Integration Services (14), and Reporting Services (2). It won the "SQL Heroes 2008" contest award as announced at t... [More]
Dec
29
2008

Read and write SharePoint lists from Integration Services packages

Since the release of SQL Server 2005 Integration Services, there has been an unanticipated amount of interest in reading and writing SharePoint data from SSIS packages. Microsoft developer Kevin Idzi recently filled this need by releasing the SharePoint List Source and Destination components on the Microsoft SQL Server Community Samples: Integration Services site on Codeplex. Kevin also deserves a lot of credit for aggressively fixing bugs, adding features, and responding to customer comments and issues. ... [More]
Nov
10
2008

Learn more about using Change Data Capture (CDC) in SSIS 2008

SQL Server 2008 Enterprise includes the new Change Data Capture feature, or CDC, largely intended for use by ETL developers performing incremental loads of a data warehouse. With CDC, you can easily identify rows that have been inserted, updated, or deleted -- no more need for complex queries and other custom solutions! The other day I promised links to some resources, and now they're finally all online. Try the 2 new end-to-end samples on Codeplex Sandra Ward, the developer of CDC, has done extraordinary w... [More]
Aug
21
2008

New SSIS samples from dev team and doc team

While the Integration Services development team has been busy finishing the custom component and code samples that Matt Masson recently blogged about, my hard-working colleague Carla Sabotta has been wrapping up a couple new package samples along with a new tutorial that walks through the steps of using the Import and Export Wizard. The dev team's code samples are largely intended for developers, while the package samples and tutorials are intended to benefit beginning users of Integration Ser... [More]
May
13
2008

Dynamic package generation, and Codeplex

After reading the recently-posted "Build a Metadata-Driven ETL Platform by Extending Microsoft SQL Server Integration Services" article on MSDN, I hunted all over the page for the link to some sort of sample, and there wasn't one! Personally, I'd rather have someone give me a push in the right direction with some sample code after describing such an elaborate architecture. It's not a weekend afternoon project, after all. Turns out the real thing is an internal Microsoft tool (&quo... [More]