Could not load package ... because of error 0xC0010

[Peager]

I'm a newbie at SSIS. I have a package that I've been able to install on my SSIS server which is running on the same machine as my SQL server. The SQL code I am running is below:

DECLARE  @cmd		VARCHAR   (1000) 
SELECT @cmd = 'dtexec /SQL "\Load Columbia River" /SERVER MCSQL2008 /USER SSIS /PASSWORD vdf1sgr8' 
EXEC MASTER..xp_cmdshell    @cmd

The code 'almost' runs.... I get the following output results:

Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2531.0 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started:  6:29:10 PM
Could not load package "\Load Columbia River" because of error 0xC001000A.
Description: The specified package could not be loaded from the SQL Server database.
Source: 
Started:  6:29:10 PM
Finished: 6:29:11 PM
Elapsed:  0.141 seconds
NULL

Can anyone give me a tip on what I'm doing wrong?

Thanks,

Paul

 

[mrdenny]

The easiest way to get the command correct, is to setup a SQL Agent job to run the package. Then get all the parameters from the last tab in the UI.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[Peager]

Thanks for the idea. I solved the problem earlier yesterday. There were two problems. 1) The 'path' to my package was wrong. I had to re-import the packages into the SSIS server and, 2) the 'user' needed SysAdmin privileges. The code I posted above worked perfectly after these changes.