Categories: SSIS

Skip Validation of SSIS Packages

There’s been an update of the SSIS extension for Visual Studio 2019. There are some bug fixes and deployments are blocked to Azure-SSIS if the target server version is not SQL Server 2017, but the real killer feature is the ability to now skip validation of an SSIS package when you open it.

This might not seem like much, but I had a project where there were many connections to different source databases. Sometimes, a couple of them were offline. Every time I opened up a package, the connections were validated. Because some of them were offline, I had to wait for the time-out and then the connection manager would be put offline. Opening up a package could easily take a minute or more. With this feature, packages now open up in a few seconds. It has already saved me a lot of frustration 🙂

So how does it work? You install the latest version of the extension. You open up Visual Studio, you go to Tools > Options. Go to the section Business Intelligence Designers, then Integration Services Designers and then General.

You’ll find an option under Skip package validation. It’s deselected by default.

Just enable it and enjoy the ride!

p.s.: the official blog post says it should also work with SSDT for VS2017 15.9.6, but I haven’t tried it out yet.
p.p.s: this is something different than the DelayValidation property you can set on various object inside a package. This property delays validation of the object at runtime, until the object itself is actually used. Useful when you use expressions on those objects. The setting described in this blog post is a design-time feature.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

  • That seemed promising, but it just deferred the hang-up until it was time to validate the Excel Connection when mapping its columns. Validating Excel Source Fills about 85-90% of a progress bar then hangs forever. This happens using a local drive or one on the share, even if the data flow task is the only thing in the package.

Recent Posts

Book Review – Agile Data Warehouse Design

I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…

4 days ago

Cloudbrew 2024 – Slides

You can find the slides for the session Building the €100 data warehouse with the…

1 week ago

Book Review – Microsoft Power BI Performance Best Practices

I was asked to do a review of the book Microsoft Power BI Performance Best…

1 month ago

Create a Numbers Table in Power Query

This is a quick blog post, mainly so I have the code available if I…

1 month ago

Microsoft finally adds Tenant Switcher for Fabric / Power BI

Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…

1 month ago

Book Review – Humanizing Data Strategy by Tiankai Feng

This book was making its rounds on social media, and the concept seems interesting enough…

1 month ago