Welcome to TechNet Blogs Sign in | Join | Help

SQL Server Integration Services (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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
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 | 0 Comments
Filed Under: , , , , ,
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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , ,
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
posted by Mat_Stephen | 1 Comments
Filed Under: , ,
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
posted by Mat_Stephen | 0 Comments
Filed Under: , , , , , ,
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
posted by Mat_Stephen | 0 Comments
Filed Under: , ,
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
Filed Under: , , ,
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
posted by Mat_Stephen | 1 Comments
Filed Under: , , ,
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
Filed Under: , , ,
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
Filed Under: , , ,
Tuesday, May 03, 2005 8:00 AM

Another Blog with an interesting fuzzy logic example using SQL Server Integration Services to process web server logs

For those of you interested in implementing fuzzy logic in SQL Server Integration Services Jamie Thomson's Blog has a very good blog post on the subject with an interesting real world example that overcomes a challenging performance problem. 
posted by Mat_Stephen | 0 Comments
Filed Under: ,
Tuesday, April 26, 2005 6:03 AM

SQL Server 2005 Integration Services - Migrating SQL Server 2000 DTS tasks

I have extracted the following from a useful article: SQL Server 2005 Integration Services: Lessons from Project REAL, http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsql90/html/SQL05InSrREAL.asp   SQL Server 2005 Integration
posted by Mat_Stephen | 0 Comments
Filed Under: ,
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
posted by Mat_Stephen | 1 Comments
Filed Under: , ,