Tactek Data Systems is pleased to announce TacTools for SSIS: Null Manager. This data flow component designed for Microsoft SQL Server Integration Services 2008 helps overcome the challenges of dealing with NULL values in various SSIS tasks.
Microsoft SQL Server
Live Table Load with SQL Server Integration Services
There are many techniques for doing quick, full loads of data with Microsoft SQL Server Integration Services (SSIS) for a reporting environment. This one is the quick change artist of the bunch. Our goal is to create a mechanism for doing a full data table load with little to no interruption to production reports that may rely on that table’s data. We’re going to quick load 30,000 or more records of data in the blink of an eye using a very simple, if commonly overlooked, technique. (continue reading…)
Improved fnSplit Function for SQL Server
Yesterday, I posted a relatively well-known table-value function called fnSplit() for Microsoft SQL Server that splits delimited data from a single field into multiple data rows. Today, we will improve on that function by including an index number column and retaining null entries within the array. (continue reading…)
Query HP Service Manager Arrays in SQL Server
While the HP Service Manager client is a great tool, sometimes you still need to run a direct SQL query on the data. You may want the data to appear on some external report or you just need some “quick and dirty” numbers to send on to management. If you manage HPSM environments long enough, you will invariably find yourself connecting to the database to run queries from time to time. And that’s when you’ll discover that HPSM has been storing the data you need in a difficult-to-query array.
Although the example in this article applies to HP Service Manager, the method can be used whenever delimited data needs to be split and joined to another table in Microsoft SQL Server.
