Fahad349


I am trying to run an SSIS Package by using DTRun.exe this way
C:\Documents and Settings\Fahad>dtexec /SQL DataDownload /Conn "Data Source
=TriMurti;User ID=sa;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate
=False;Password=gamba" /U sa /P gamba

And the outcome of the command was
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 9:03:52 AM
Could not load package "DataDownload" because of error 0xC001000A.
Description: The specified package could not be loaded from the SQL Server database.
Source:
Started: 9:03:52 AM
Finished: 9:03:52 AM
Elapsed: 0.25 seconds


-----------------------------
Any help in this will sincerely be appreciated.


Fahad




Re: Could not load package because of error 0xC001000A

Phil Brammer


Are you running this on the same server where SQL Server is located (I don't see a /Server option, so I assume so) It is saying that it cannot find the package.

Have you logged into Integration Services with the user "sa" and verified that you can find the package






Re: Could not load package because of error 0xC001000A

Fahad349

Package is there. I have created an SQL Agent schedule and it runs fine.

No, I am not on same server.






Re: Could not load package because of error 0xC001000A

Phil Brammer

 Fahad349 wrote:
Package is there. I have created an SQL Agent schedule and it runs fine.

No, I am not on same server.


Then I believe you need to use the /Server switch on your dtexec command line.

http://msdn2.microsoft.com/en-us/library/ms162810.aspx





Re: Could not load package because of error 0xC001000A

Fahad349

 Phil Brammer wrote:

Fahad349 wrote:
Package is there. I have created an SQL Agent schedule and it runs fine.

No, I am not on same server.


Then I believe you need to use the /Server switch on your dtexec command line.

http://msdn2.microsoft.com/en-us/library/ms162810.aspx


Thanks Phil. I appreciate it.





Re: Could not load package because of error 0xC001000A

EDUARDO_SENGER

A little hand,

If you are at command prompt, to run a package you need to use dtexec /f "d:\backup\teste.dtsx"

use f for file system.

I received the same message when I was at command prompt using the option dtexec /sql

I hope it help.

senger