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]
Apr
6
2010

Webcast: Managing SSIS Package Deployments with PowerShell

Sign up to watch Session 18 of "24 Hours of PASS" on Wednesday, May 19th. This is the only SSIS session out of 24...understandable, maybe, since there are no new SSIS features in SQL Server 2008 R2 "Kilimanjaro." Here's the signup page and list of sessions: https://www323.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=7sh5kdvjm47xplbf Here's the "more information" page: http://www.sqlpass.org/24hours/2010/ Here's the session description, copied and pas... [More]
Apr
5
2010

Download beta of new 64-bit Excel driver

<tap><tap> Is this thing on? If you've been curious to test the 64-bit version of the provider and driver for Excel, you can download it from: http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en You specify "Excel 14.0" in the Extended Properties string if, in fact, your are connecting to an Office 14 file. Keep in mind that the 32-bit and 64-bit providers cannot be installed side-by-side. As previously discussed here... [More]
Mar
10
2010

SSIS product team is looking for a senior developer (Redmond, WA, USA)

For more information, see https://careers.microsoft.com/JobDetails.aspx?jid=13164. -Doug  
Feb
6
2010

Thank you for following me. Comments are now disabled.

Thank you all for following my "Dougbert on SSIS" blog. As I mentioned in a recent post, I am no longer working on SQL Server Integration Services at Microsoft. While I still expect to spend time with SSIS, I won't have as much time or as much fresh information. So this blog will probably not be very active. But no harm in staying subscribed! I'm sure that I'll never escape from Excel driver issues. (And there are so many custom tasks and data flow components that need writing! How ab... [More]
Jan
18
2010

You could be doing ETL or BI at Microsoft!

If you enjoy using the features of SQL Server for ETL or business intelligence projects, consider working close to the source right here at Microsoft. Check out our public careers page at: https://careers.microsoft.com/. The other day I just happened to be clicking around on our internal job-listing site. (See previous blog posting). I found a fair number of job openings for many ETL and BI-related terms and phrases: ETL, 25 SSIS, 16 Integration Services, 9 OLAP, 33 SSAS, 8 PowerPivot, none Analysis Servic... [More]
Jan
7
2010

SSIS: Now it's play and not work!

For me, that is. I hope. No, I haven't written any magic code that fixes the tedious parts of Integration Services. But in 2010 I will no longer be working on SSIS documentation at Microsoft; I am moving to a new and different role on the SQL Server documentation team. So my theory is that I can now play with SSIS for fun in that "spare time" that we all fantasize about. Don't be too hasty to unsubscribe from this blog! I hope that I will still have information to contribute from time to time. SSIS has both... [More]
Nov
21
2009

Importing from Excel: IMEX and mixed data types

When we talk about using import mode, "IMEX=1," to resolve a common problem when importing from Excel, we sometimes give or get the impression that setting IMEX=1 automatically imports all data as text. This is an over-simplification. In fact, IMEX=1 causes the value of the Registry setting, ImportMixedTypes, to be applied. ImportMixedTypes commonly has a value of Text. Therefore, if and only if you have a column that contains both numbers and strings, all the values in that column are imported 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]
Nov
9
2009

New book: SSIS Problem - Design - Solution

Microsoft SQL Server 2008 Integration Services Problem-Design-Solutionby Erik Veerman, Jessica Moss, Brian Knight, and Jay HackneyISBN: 978-0-470-52576-0Paperback, 480 pagesPublished by Wiley/Wrox in November 2009List price: US $49.99Amazon price US $31.49 as of 11/9/2009.Also available from Wiley as an Adobe E-Book.Not yet available from Amazon for Kindle, as of 11/9/2009. In Microsoft SQL Server 2008 Integration Services Problem-Design-Solution, a new book from Wiley/Wrox, 4 recognized SSIS experts... [More]