When executing an SSIS package that is stored in the MSDB database (i.e. stored in SQL Server) you may experience an error message like this:
Could not load package "\PACKAGENAME" because of error 0xC0014062.Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.
In my situation the SQL Server database where the SSIS package is deployed is a named instance. There is no default SQL Server instance on the server. The command line that I used to execute the package was:
DTEXEC /SQL "\PACKAGENAME"
The problem is that the above command is trying to load the SSIS package from the MSDB database in the default instance of SQL Server and there isn't one. The solution is quite simple; add the /SERVER command line parameter with the server\instance of the SQL Server; e.g.
DTEXEC /SQL "\ADSECURITYSYNC" /SERVER "SERVERNANE\INSTANCENAME"
Subscribe to:
Post Comments (Atom)
1 comments:
You just need to loose the back (or forward) slash in front of your package name
Post a Comment