Skype for Business
See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Mat Stephen's SQL Server WebLog
All things SQL Server. Complied by Matthew Stephen - SQL Server Product Specialist, Microsoft UK
Analysis Services 2005
Free SQL Server Tools, Utilities and Addins
High Availability and Disaster Recovery
Performance Top Tips
Post Event Follow Up
SQL 64 bit
SQL Server 2000
SQL Server 2005
SQL Server Integration Services
SQL Server Security
Browse by Tags
Mat Stephen's SQL Server WebLog
sql server integration services
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 continually published to this website http://www...
30 Aug 2005
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. Thanks Jamie! http://blogs.conchango.com/jamiethomson/archive...
3 May 2005
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 package designer?” The answer I have is, for...
14 Jun 2005
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 . The...
4 Oct 2005
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.
11 Jun 2005
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 similarity values are calculated - I had no idea,...
7 Apr 2005
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 applications manage metadata and information...
3 Jan 2006
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, accuracy and the most cherished of properties...
23 May 2005
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.
10 Jun 2005
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 Services is a completely new product. While it is able...
26 Apr 2005
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
2 Jan 2006
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 samples that come with the product. Here's the...
15 Sep 2005
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. I know I'm going to find it very useful...
12 Jul 2005
© 2015 Microsoft Corporation.
Privacy & Cookies