(r.stropek) SSIS has a built in function for loops. In this blog article I want to demonstrate how to use SSIS’s Foreach ADO enumerator to loop through a list of SQL server names and collect some basic data (e. g. name, language, version, etc.) about them.
Author: SSWUG Research
Sorting SQL Project Files in SQL Server Management Studio
(Jasper Smith) When you have a lot of SQL files in a SQL Server Management Studio (SSMS) Project or a lot of Packages in a SSIS Project, it can become difficult to find the file or packages you are looking for as the order that they are displayed in the Solution Explorer is the order they were added
When It’s Time to Change
(Alex Keh) Oracle supports .NET developers in a variety of ways. Oracle Data Provider for .NET (ODP.NET) offers many features, including support for new Microsoft ADO.NET 2.0 features, such as factory classes. And as part of Oracle Database 10g Release 2, database change notification allows a .NET c
Database Visualization
(VGirish) When handling a project with hundreds of tables, it takes some time to understand the flow within the database. Especially so if there is no document available. A possible scenario is legacy code up for maintenance or migration. After going through just a few tables, it starts to become to
Table Partitioning in DB2 Viper – Details Part 3
(Chris Eaton) So far we have discussed new DB2 Viper Table Partitioning overview, the details on creating a partitioned table and how to attach new partitions. In this posting we will cover the DETACH operation.
Working with LINQ Using Visual Studio 2005
(Satheesh Kumar) LINQ is the general-purpose standard query operator that allows traversal, filter and projection operations to be expressed in a direct yet declarative way in any .NET programming language. The extensibility of the LINQ query language provides implementations that work over both XM
On disk performance and MySQL replication
(Jeremy Cole) If you’re not using replication, the only thing you have to worry about is MyISAM and InnoDB performance. There are a lot of things you can easily do to get more (or less!) performance out of either of them. So, you get your system tuned and handling 1500 updates per second, easy as pi
Tricks for Processing SQL Scripts
(Josef Finsel) SQL Server 2005’s Management Studio offers lots of new functionality, but you can’t always use a GUI. Sometimes you need to run a script from the command line, especially for an upgrade or install script. Previous versions of SQL Server had two command-line utilities: ISQL, which uses
IBM’s Enterprise Generation Language Leverages Existing Business Developers Skills to Expedite Java/J2EE and SOA Development
(Rikki Kirzner) Business transactions running on IBM zSeries and other mainframes are rapidly increasing with the growth of Internet-based computing and IBM forecasts mainframe-based transactions to double by 2010. Meanwhile, Service Oriented Architecture (SOA) has become a key strategic initiative
Converting CSV Data to Objects
(Jeff Brand) CSV files are still found all over, and developer’s often are faced with situations for parsing and manipulating that data. Often times, we want to take the CSV data and use it to initialize objects. In this article, we’ll take a look at one approach to mapping incoming CSV data to our