29 09 2010
Could not load package "\MSDB\MySSISPackage" because of error 0x80131500.
Came across an interesting error whilst thrashing out some deployment automation scripts today.
As part of the deployment it was executing a SSIS package using DTExec running on the machine local to SQL Server, thus as part of the command line it omitted the /SERVER switch, insinuating that the package I’m executing exists in the default instance. However, DTExec was throwing me this error message:
Microsoft (R) SQL Server Execute Package Utility
Version 10.50.1600.1 for 64-bit
Copyright (C) Microsoft Corporation 2010. All rights reserved.
Could not load package “\MSDB\MyPackage” because of error 0x80131500.
Description: The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic “Configuring the Integration Services Service” in SQL Server 2008 R2 Books Online.
Login failed for user ‘VM\_svc_ssis_packages’.
Elapsed: 0.344 seconds