The SQL Server 2005 product family has now been announced, so with four editions available, what does this mean for SQL Server Integration Services? Starting from the bottom we have the free edition known as Express, and the entry level Workgroup edition, and neither include the full IS product. They have the Import/Export capabilities, but nothing more, so for simple loading and extraction of data this should suffice, but you will not be able to build packages.

Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003

by Additional Articles

MSDN Communities

Miscellaneous

In the second of this three-part series, learn how to map well-formed XML from a standard SQL Server query to a single cell in a worksheet. The resulting output is an XML tree with non-repeating elements.

BDS SQL Digger 2.0 Released

by Press Release

SQLServerCentral.com

Product News, Releases, and Upgrades

Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.

Flexible DTS Packages with Perl

by Jeremy Brown

SQLServerCentral.com

SQL Server 2000 DTS was a revolutionary programming environment, but one that was not without a few quirks. As often found with many Microsoft products, there were sections in your packages where things were hard coded, making them less flexible. New author Jeremy Brown brings us a look at how you can build extremely flexible packages using Perl.

Part 1: Automating the XML Data Mapping Process in Excel 2003

by Additional Articles

MSDN Communities

Miscellaneous

In the first of a three-part series, learn how to use XML maps to customize Excel as a data input and display system.

Know Your Data

by Roy Carlson

SQLServerCentral.com

Advanced Querying

Or at least the types of your data. New author Roy Carlson was working in SQL Server 2000 to calculate some values based on row counts, sales amounts, etc. and discovered some interesting results. Without his sharp eye, a number of individuals would have been upset by the resulting lack of commissions, as may some of your clients. Read about some potential problems in your calculations if you are not careful with your data types.

Tableau Software Debuts

by Press Release

SQLServerCentral.com

Product News, Releases, and Upgrades

With it's VizQL, Tableau Software is revolutionizing the way that you will analyze data. Built to work with multiple data sources, including SQL Server databases and Analysis Services cubes, this software will amaze you.

Multi-User Considerations in Data Synchronization for SQL Server 2005

by Additional Articles

MSDN Communities

Replication

Gain a better understanding of how to develop your SQL Server Mobile applications to handle multi-user access and data synchronization with Microsoft SQL Server 2005.

HIGHER SOURCE RAISES STAKES IN INTERNET INDUSTRY

by Additional Articles

Other

The Lighter Side

Microsoft Corporation has announced plans to acquire the
Website and Internet development corporation Higher Source for an
undisclosed fee.

Learn SQL Server 2005 In Reading

by Press Release

SQLServerCentral.com

User Groups

Are you looking for a head start on learning about SQL Server 2005? Able to get to Reading in the UK in May? One of the premier SQL Server MVPs, Itzik Ben Gan, is teaching a full day seminar on Advanced T-SQL, covering both SQL Server 2000 and 2005 on May 3rd.

SQL Server 2005 Editions and Integration Services

Part 2: Mapping XML from SQL Server to a Single Cell in Excel 2003

BDS SQL Digger 2.0 Released

Flexible DTS Packages with Perl

Part 1: Automating the XML Data Mapping Process in Excel 2003

Know Your Data

Tableau Software Debuts

Multi-User Considerations in Data Synchronization for SQL Server 2005

HIGHER SOURCE RAISES STAKES IN INTERNET INDUSTRY

Learn SQL Server 2005 In Reading

Blogs

Finding fields used in a Power BI report in PBIR format with Semantic Link Labs

Adding Test data to msdb.sysjobhistory

Microsoft Ignite Announcements Nov 2024

Forums

Primary and Secondary Filegroup

Import data from json file with special characters

% processor Time in Activity monitor is greyed out

Question of the Day

The Hash Join II