Notes on SQL

Random articles from a puzzled DBA

Subtitled – And I can’t edit them with VS 2010 either. Background I am currently testing our upgrade process, for moving all of our databases from SQL Server 2012 instances to SQL Server 2016. The SSIS projects that use the ZappySys PowerPack tools are failing with a particularly unhelpful message. In addition, attempts to open …

Continue reading

The full message will also contain “The version number cannot be greater than the current version number”. Behaviour I have an SSIS package installed in an SSISDB which is on a server that run SQL Server 2012 (server A) and it needed to be copied to another 2012 instance (server B). My workstation has SQL …

Continue reading

Background On a Dev server I have used Visual Studio 2010 to build and test an SSIS package. Having completed all of my testing I have now created an Agent task with the SQL Server instance on the same box, that should execute the dtsx package. However, when it attempts to execute it fails and …

Continue reading