Jan
19
2009

Learn more about Lookup and its new features: A compilation

The SQL Server Integration Services team added valuable new caching options (and scalability) to the Lookup transformation in SQL Server 2008. Learn more about these enhancements (and about the Lookup transformation in general) from the following resources. Microsoft resources In SQL Server Books Online (BOL) Upgrading Lookup Transformations The section Caching the Reference Dataset in the Lookup Transformation topic. How to: Implement a Lookup in No Cache or Partial Cache Mode How to: Implement a Looku... [More]
Jan
19
2009

Scan the list of Microsoft Support articles for Integration Services

If you've had a seemingly obscure problem with Integration Services, you may not be alone! Microsoft Support may already have explored it and documented it in a Knowledge Base article. Here's a list of the published KB articles for SSIS, both 2008 and 2005. A big thanks to my buddy in Support, Jason Howell, invisible and tireless hero of SSIS, for the queries that helped me to produce these lists quickly. Keep in mind that you can use a free service like KBAlertz to stay up to date on newly-rele... [More]
Jan
19
2009

Stay up to date on SSIS downloads, articles, and community buzz

Looks like everyone's New Year's resolution was to get their Web sites in shape! New RSS feeds for Integration Services downloads, articles, and community content You can now stay up to date on the latest Integration Services downloads, articles, and community content by subscribing to the RSS feeds that we've made available on the SSIS portal page on MSDN and TechNet. We've been refreshing the news on the page every 2 weeks. In our "Community Buzz" column, we bring together some... [More]
Jan
15
2009

Using PowerShell with SSIS: A compilation

All the buzz over Windows PowerShell has aroused my curiosity, but it's hard to justify spending the time to learn it if it doesn't have something to do with SQL Server Integration Services. So I tried to dig up some justification by searching around for "PowerShell AND SSIS". There's not much so far, but here's what I found... General discussion Buck Woody (Microsoft): Why would I use PowerShell when I have SSIS, stored procs, batch files and other mechanisms? MVP Jamie Thomson... [More]
Dec
29
2008

Off topic: Talking SQL Server on an Italian beach

In the midst of the recent snowfall that put the Seattle area out of business for 10 days, one sunny spot (advance pun) was a Christmas email from SQL Server MVP Andrea Montanari. I haven't seen Andrea in person since the MVP Summit in 2006 or 2007. All of us on the database-related Support teams at Microsoft knew Andrea's name because he wrote DbaMgr, which was the only management UI available for MSDE when MSDE was first released.   Andrea's also unique because he's not a DBA or a consultant, but an... [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]
Dec
16
2008

Design DTS packages reliably on Windows Server 2008 and Vista

Yesterday (Monday, Dec 15, 2008) Microsoft released Service Pack 3 for SQL Server 2005. This release includes an update to the Feature Pack, which includes the DTS Package Designer components for use with SQL Server 2005 Integration Services and SQL Server 2008 Integration Services. (There is NOT a separate release for SQL 2008.) This update fixes some issues that were discovered on Windows Vista and carried over to Windows Server 2008. To download the updated DTS package designer, Visit the SQL Server ... [More]
Nov
18
2008

See all the new SSIS articles, videos, and samples from Microsoft

Have you seen all the recent articles, videos, & samples for Integration Services? In the future, we hope to offer you an RSS feed for this purpose, but we're not there yet. For now, I hope that you find this list useful, especially since it was painfully tedious to create! (Note: When I look at this blog posting in Internet Explorer, I get an unexpected warning from the IE Phishing filter...probably because of all the hyperlinks set to open in a new window. I can reassure you that the only danger ... [More]
Nov
14
2008

Your vote on Microsoft Connect influenced SQL Server 2008 Service Pack 1

Your vote counts on Microsoft Connect! The SQL Server product team looked closely at Connect bugs from our customers to plan the fixes that will be included in SQL Server 2008 Service Pack 1. After setting aside feature requests (DCRs), they started at the top of bugs with the most votes, and worked their way down (in number of votes) until they reached the limit of what can realistically be fixed in time for SP1. It was time and resources that decided the number of bugs to fix, not a predetermined mag... [More]
Nov
11
2008

Add logging to the Data Profiling Task

Yesterday I was on a call where we looked at a few usability requests for the Data Profiling Task that didn't make it into RTM. One such request was task-specific logging. Surprise! The attentive developer at Microsoft Research had added it at the last moment, and few people had noticed. So this feature is not mentioned in BOL. Enabling task-specific logging for the Data Profiling task There's a DataProfilingTaskTrace logging event that's unique to this task that you want to enable, to capture... [More]