Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server Inte... » Business Intelligence   (RSS)
Tuesday, January 03, 2006 5:14 PM

SQL 2005 Metadata Samples Toolkit and whitepaper now available

Reposted 10/1/06 to include in 'free tools' category I'm constantly asked "what's Microsoft doing about metadata and do we have a solution." In the old days (SQl 2000 and 7), Microsoft provided Meta Data Services, a platform designed to help tools and
Posted by Mat_Stephen | 0 Comments
Monday, January 02, 2006 5:15 PM

New SQL 2005 code samples available

I guess now the pressure is off to release the product we'll see more useful samples comming out of corp; here's a link to the latest December update: http://msdn.microsoft.com/sql/downloads/samples/default.aspx
Posted by Mat_Stephen | 2 Comments
Tuesday, October 04, 2005 1:07 PM

Microsoft .NET Data Provider for SAP

After my recent SQL 2k5 BI session, here at TVP Reading, I had an enquiry asking for more info regarding the SAP provider I showed in the list of providers available to SQL Server Integration Services . The best public information I can find is @ http://msdn2.microsoft.com/en-us/library/ms216599
Posted by Mat_Stephen | 0 Comments
Thursday, September 15, 2005 5:27 PM

SQL Server Integration Services Samples - Including Fuzzy Logic

At a recent Technet presentation, someone came up to me and asked me if I could post my Fuzzy Logic sample package to my Blog. I confess I haven't got round to wrapping it all up, but now it looks like I'm off the hook as one has been supplied with the
Posted by Mat_Stephen | 1 Comments
Tuesday, August 30, 2005 4:27 PM

Project REAL—Business Intelligence in Practice - great website!

For sometime a group of Program Managers from the SQL BI team have been working with a customer, Barnes and Noble, to produce a SQL BI solution for their data warehouse and analysis needs using SQL 2005. The leasons learnt from all their work is being
Posted by Mat_Stephen | 0 Comments
Tuesday, July 12, 2005 4:51 PM

SQL Server 2005 Integration Services - Top Reference Site

SQL Server 2005 Integration Services - Top Reference Site From the people that brought you www.SQLDTS.com we now have www.SQLIS.com . This is a top website for examples, information, news and links to MSDN, MSDNTV and blogs etc covering Integration Services.
Posted by Mat_Stephen | 0 Comments
Tuesday, June 14, 2005 3:42 PM

London roadshow follow up: Selective execution of SQL Server Integration Service Tasks and Transforms

I had a question, at the London roadshow (8th June), which I wasn’t sure if I could answer reliably, so I promised to blog the answer. The question: “Can I run selected (with mouse) tasks and transforms from inside the SQL Server Integration Services
Posted by Mat_Stephen | 1 Comments
Saturday, June 11, 2005 5:52 PM

Blogcast: How to add a multicast transform to a SQL Server Integration Services package

Here is a 4min 8sec blogcast showing how to add a multicast transform to a SQL Server Integration Services package (the package created in the previous blogcast). A multicast transform can create two or more replica data flows from one original data flow
Posted by Mat_Stephen | 1 Comments
Friday, June 10, 2005 11:15 AM

Blogcast: How to create a simple SQL Server Integration Services package

Here is an 8min 13sec blogcast showing how to create a simple SQL Server Integration Services package. The package aggregates 2 million records from a raw data file and passes the resulting 64 aggregated rows into a table in tempdb.
Posted by Mat_Stephen | 0 Comments
Monday, May 23, 2005 12:07 AM

Transfering Data Oracle Data To And From SQL Server

This post is for two purposes: firstly to point to a comprehensive blog post covering the transfer of data between Oracle and SQL Server using SQL Server 2005 Integration Services - which answers a recuring question from customers and partners with insight,
Posted by Mat_Stephen | 0 Comments
Thursday, April 07, 2005 4:11 PM

Microsoft SQL Server 2005 fuzzy logic in matching and grouping - how does it work in SQL Server Integration Services?

Following on from a presentation 'First Look at SQL Server Integeration Services' to some MVPs here at TVP Reading, I am responding to the a question I was asked, 'how does SQL Server's fuzzy logic work'. I was meant to explain how the confidence and
Posted by Mat_Stephen | 1 Comments
 
Page view tracker