Run Packages through CMD line - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Analysis Server and Reporting Services (2012)

Run Packages through CMD line

Author

Topic

vijays3
Constraint Violating Yak Guru

354 Posts

Posted - 2015-04-28 : 05:14:19

Hi All

I have upgraded my 2005 packages in 2012,I have found the different
deployment process in to deploy the packages . While deploying these
Package It does ask to create SSISBD catalog which I have created and
I have deployed all my packages in that catalog .
Now I want to test this package to run from command utility
like this

C:\Program Files\Microsoft SQL Server\110\DTS\Binn>dtexec /sql StarsPermanentPer
iodDelete.dtsx /server CORPCVI8086Z\MSSQLSERVER_2012
Microsoft (R) SQL Server Execute Package Utility
Version 11.0.2100.60 for 64-bit
Copyright (C) Microsoft Corporation. All rights reserved.

Started: 4:12:39 AM
Could not load package "StarsPermanentPeriodDelete.dtsx" because of error 0xC001
000A.
Description: The specified package could not be loaded from the SQL Server datab
ase.
Source:
Started: 4:12:39 AM
Finished: 4:12:39 AM
Elapsed: 0.032 seconds

But this is thowing an error

Could not load package "StarsPermanentPeriodDelete.dtsx" because of error 0xC001
000A.
Description: The specified package could not be loaded from the SQL Server datab
ase.

Kindly please suggest me on this.

Vijay is here to learn something from you guys.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-28 : 11:44:25

I think this was fixed in SP1 and Cumulative Update 5 for SQL Server 2012

https://support.microsoft.com/en-us/kb/2742131

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources