Notes on SQL

Random articles from a puzzled DBA

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