Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SSIS   (RSS)
Thursday, November 12, 2009 11:29 AM

Something new for SSIS in SQL Server 2008 R2 November CTP

Ok, so it turns my previous post about R2 wasn’t entirely correct. SSIS does have one new feature which appears in the latest SQL Server 2008 R2 CTP . If you open up the ADO.NET Destination UI, you’ll notice a new “Use Bulk Insert when Possible” check
Posted by mmasson | 0 Comments
Filed under: , , ,
Tuesday, March 10, 2009 9:26 AM

SSIS Team Blog – Now in Chinese

Xiaochen Wu, a member of our Shanghai team, has started a Chinese SSIS blog . He’s started it off by translating some of the posts I’ve done, and I’m sure he’ll find plenty of content in the future. I don’t know what the following text means, but I assume
Posted by mmasson | 0 Comments
Filed under:
Wednesday, May 28, 2008 11:08 AM

Matthew Roche on RunAs Radio

Matthew recently did an interview for RunAs radio where he gives a really good overview of SSIS, DTS, and ETL in general. It's great if you're just getting started with SSIS, or need to sell someone else on the idea of using it!
Posted by mmasson | 0 Comments
Filed under:
Wednesday, February 27, 2008 1:58 PM

SSIS sets an ETL world record

They mentioned the TPC benchmark results at the SQL Server 2008 launch today. The final paragraph mentions a world record for ETL load performance. The fine folks who maintain the SQLPerf blog have posted details about the result , explaining how they
Posted by mmasson | 3 Comments
Filed under: ,
Tuesday, January 22, 2008 5:03 PM

What's new in SQL Server 2008 for SSIS - Part two

Change Data Capture (CDC) While not a direct SSIS feature, the new Change Data Capture functionality in 2008 can be taken advantage of in SSIS to do incremental loads. CDC captures changes to SQL Server tables (inserts, updates, deletes), and makes them
Posted by mmasson | 4 Comments
Filed under: ,
Thursday, January 10, 2008 5:04 PM

What's new in SQL Server 2008 for SSIS - Part one

Improved Scripting SQL Server 2008 (Katmai) introduces VSTA as our new scripting engine, which replaces the old VSA engine used in SQL Server 2005 (Yukon). There are a number of advantages to the new engine, but I think the feature users are most excited
Posted by mmasson | 12 Comments
Filed under: ,
Tuesday, November 20, 2007 2:43 PM

SSIS Survey

The SQL User Experience (SQLUX) and Integration Services team are currently conducting a survey on ETL practices. We hope to use this feedback in our planning for the Katmai end game, and follow up releases. If you fill out the survey before December
Posted by mmasson | 0 Comments
Filed under:
Friday, September 14, 2007 5:33 PM

Running packages from custom applications

There are a lot of different ways to run SSIS packages , and many situations call for a custom package launcher application. If you're coding your own launcher, one thing to keep in mind is that certain SSIS functionality (such as the Script task / component)
Posted by mmasson | 1 Comments
Filed under:
Tuesday, June 05, 2007 8:06 AM

First public Katmai CTP

The first public community technology preview for SQL Server 2008 (code named Katmai) was announced at TechEd yesterday, and is now available for download. You can register here to download the developer editions, and post questions / comments / concerns
Posted by mmasson | 1 Comments
Filed under: ,
Friday, June 01, 2007 10:14 AM

Real world scenarios

May has been a busy month! The first Microsoft Business Intelligence conference was earlier in the month, and it seemed to be a big success. I was amazed at how many people were there, and I met a lot of interesting people when I was manning the demo
Posted by mmasson | 2 Comments
Filed under: ,
Tuesday, February 27, 2007 7:47 PM

SQL Server SP2 – What’s new for SSIS

You can see all of this information on MSDN in the SP2 Readme , but I thought I'd highlight a couple of things. Diagnostic Logging A lot of trace logging was added in SP2 to help with debugging connectivity issues. These messages are logged using the
Posted by mmasson | 1 Comments
Filed under:
Wednesday, January 31, 2007 10:20 AM

SSIS connectivity white paper

A connectivity white paper writen by Bob Beauchemin has been added to the connectivity wiki site . Definitely worth checking out.
Posted by mmasson | 0 Comments
Filed under: ,
Wednesday, November 08, 2006 4:07 PM

Stored procedures with output parameters

When executing Stored Procedures with the Execute SQL Task, SSIS passes the statement to the underlying provider without parsing it. While efficient, the different ways of handling the input between the various providers can be a little frustrating. I
Posted by mmasson | 2 Comments
Wednesday, November 01, 2006 5:06 PM

Conditional Constraints

Here's a more practical example of using constraints based on variables. I have a package that requires an existing database file to be attached to the local SQL Server. The package is synced out to multiple machines from a source control system and run
Posted by mmasson | 3 Comments
Monday, October 30, 2006 3:49 PM

Using Constraints and Expressions

Besides the regular Success and Failure constraints, you can create precedence constraints that are linked to an expression. In this example, I have a Script Task that determines the course for the workflow. Besides the pass and fail, I also want to handle
Posted by mmasson | 1 Comments
 
Page view tracker