SQL Server now has its own section on codeplex (Microsoft's open source project hosting site). This site includes all of the samples that come with SP2, in a single-serve format. Each product has a section, so you can grab samples for individual products...

Be sure to check out Michael Entin's recent blog post about the various options available for running your packages programmatically.

A number of "guided tour" videos have been put up on the Microsoft.com website . Experienced users might not get much out of then, but they are great to give new users an overview of SSIS features and functionality.

If you're running Vista and have SP2 installed, you might require a special hotfix to get packages containing a script task to work correctly . This is due to a recent fix in the .NET CLR which affects the use of VSA on Vista.

Denise Draper, the Product Unit Manager (PUM) for SSIS, has started a BI Recruiting blog for the Integration Services, Reporting Services, and Analysis Services teams. From the description: Expect to see articles highlighting teams, roles, projects...

In case you're one of the many people stuck working on last minute DST changes, you'll be happy to know that there's no special patch needed for SSIS - everything will be taken care of by the OS patches. The only component of SQL Server affected is Notification...

A post in the forums had me try out what turned to be a dangerous combination of flags in the Transfer SQL Objects task. The user said they were no longer able to access their database after running their package, and I was curious as to why this would...

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...

SP2 has been officially released, and can be found here: http://www.microsoft.com/sql/sp2.mspx

A connectivity white paper writen by Bob Beauchemin has been added to the connectivity wiki site . Definitely worth checking out.

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...

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...

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...

I guess it’s only fitting that the first blog post is about the blogger himself! My name is Matt, and I’ve recently moved to the Redmond area to work for Microsoft as a Software Design Engineer (SDE) on the SQL Server Integration Services team....