Author:Andy Leonard

You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you’ve been given an ISPAC file, you double-click it in Windows Explorer. Either …
Continue reading Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)

It’s Release Day! 🙂 New versions of SQL Server Data Tools (SSDT) are available here. SSDT 16.5 and 17.0 (RC1) are available. Also available are Data-Tier Application Framework (DacFx) versions 16.5 and 17.0 (RC1). New versions of SQL Server Management Studio (SSMS) are available here. SSMS 16.5 and 17.0 (RC1) versions are available for SSMS. …
Continue reading New Versions of SSMS and SSDT Available

You can download SQL Server vNext Evaluation Edition here. Today! :{>

I’m excited to announce CatCompare – a command-line interface (CLI) for SSIS Catalog Compare – is in pre-release testing. I plan to release the next update of SSIS Catalog Compare with an option to purchase the GUI product stand-alone or the GUI + CLI for a higher price. BUT… If you purchase SSIS Catalog Compare …
Continue reading Coming Soon: A Command-Line Interface for Managing SSIS Catalogs

Waterfall project management is a serial approach to the phases of a project. Proponents of waterfall methodologies hold it’s best to plan: gather requirements, design the solution, develop it, test it, deploy and maintain it in discrete steps. Critics maintain it is impossible to know all of the requirements prior to design or development. by …
Continue reading Agile or Waterfall?

Update: Voting is closed and the winners have been announced! Whether you get an email from the PASS organization or not, voting is now open for the PASS Board. Visit the PASS website and log in. You should see the myPASS page: If you’re eligible to vote, your page should appear similar to mine, shown …
Continue reading PASS Board Elections–Voting is Open!

The SSIS Catalog is surfaced within the SSISDB database. In this post I describe some tips for managing your SSIS Catalog database, named SSISDB. For information regarding restoring SSISDB, please see Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB). Create the SSIS Catalog To create the SSIS Catalog, connect to an instance of SQL …
Continue reading Managing the SSIS Catalog

I’m home after a day of travel that included waking up at quarter-til-early to catch a cab to SeaTac with Tim Mitchell [blog | @Tim_Mitchell], bumpy flights, and a two-hour drive back to Farmville. We had a fantastic time! Our students asked lots of interesting questions and Tim and I were, I believe, able to …
Continue reading 2017 SQL Skills SSIS Immersion Events

Microsoft released an update to SQL Server Data Tools (SSDT) 2016 on 20 Sep 2016 – the tool used to design databases, SSIS, SSRS, and SSAS solutions. I can hear you thinking, “How do I get the update, Andy?” You can get version 14.0.60918.0 here. If you have the installer for SQL Server 2016 handy, you …
Continue reading A New Version of SSDT is Available

I apologize for misleading people who read my writings and have heard me speak on the topic of the SSIS Catalog. Here’s what I recently realized: The execution_id is different from the operation_id in the SSISDB database. In the past, I complained about the execution_id and operation_id being the same value and meaning different things. …
Continue reading I Was Wrong (About the SSIS Catalog)