Skip to main content

Posts

Showing posts from May, 2025

SSIS development Tips

SSIS build config 1. Project -> Properties -> General -> TargetServerVersion = SQL Server 2022 2. Security -> Protection Level = DontSaveSensitive 3. Execution -> DelayValidation = True 4. When you create your packages in Visual Studio you can specify the Version Major, Minor, Build and associated descriptions in the package properties window. 5. SSIS Data Source connect to MS SQL How to check the Version and Build Number of an SSIS Package USE SSISDB GO --Check full version history of installed SSIS packages --NB only works for project deployment model SELECT folders.name [Folder Name] ,projects.name [Project Name] ,packages.name [Package Name] ,version_major [Version Major] ,version_minor [Version Minor] ,version_build [Version Build] ,project_version_lsn [Project LSN] ,object_versions.created_time [Installed] ,IIF(object_versions.object_version_lsn=projects.object_version_lsn,'Yes','No') [Latest Versio...