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 …
SSIS can produce an inordinate number of error messages and numbers. Some of these can even be helpful and informative. Generally accompanied by an Error Code, one of the most popular appears to be “0x80070057” and can have a number of causes. Recently I came across this particularly helpful code when creating a Slowly Changing …
Notes on SQL 