Category Archives: Deployment

More on Package Configurations

Douglas Laudenschlager from the SSIS documentation team has posted an excellent article to his unofficial SSIS blog on how package configurations are applied in SQL Server 2005 and SQL Server 2008 Integration services. Check it out here. I don’t often … Continue reading

Posted in BI, Deployment, dev, SSIS | Leave a comment

SSIS and the Package ProtectionLevel Property

This is another one of those “I could have sworn I blogged on this years ago” posts.[1] I was looking for something I’d already written that discussed the ProtectionLevel property of the SSIS Package, but search as I might I … Continue reading

Posted in Best Practices, BI, Deployment, SSIS | 9 Comments

Choosing the "Right" SSIS Configuration Location

One of the questions I get asked quite often boils down to this: "Should I store my SSIS configuration data in SQL Server or in XML configuration files?" And my every-so-helpful answer usually is: "Yes!"[1] That’s right – very accurate, … Continue reading

Posted in Best Practices, BI, Conference, Deployment, SQL Server, SSIS | Leave a comment

New SSIS Article Online on MSDN

I have a new article on the SSIS Developer Center on MSDN, focusing on Data Sources and Configurations as tools for connection reuse across sets of SSIS packages. I wrote it months ago (looking at it now it seems even … Continue reading

Posted in BI, Deployment, Katmai, SQL Server, SSIS | Leave a comment

SSIS Deployment at TechEd Online

The third and final "Tech*Talk" video interview I recorded during Microsoft’s TechEd conference this June in Orlando is now online. I talked with INETA board member Mark Rosenberg about SQL Server Integration Services deployment. You can check it out on … Continue reading

Posted in BI, Deployment, SQL Server, SSIS, Webcasts | Leave a comment

BIDS Helper and SSIS Deployment

Back in November I posted about the 1.2 release of the amazing BIDS Helper project on CodePlex and the new SSIS-related features it included. Well, the folks who contribute to the BIDS Helper project have been hard at work getting … Continue reading

Posted in BI, Deployment, SQL Server, SSIS | 3 Comments

SSIS and SQL Server Agent – Choosing the Right Job Step Type

My "SSIS and SQL Server Agent" post is the most frequently accessed post on my blog, or at least it has been for the two months that I’ve actually been tracking site usage. But some recent posts on the SSIS … Continue reading

Posted in Best Practices, BI, Deployment, SQL Server, SSIS | 7 Comments