Executing multiple SSIS packages

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 2005 Forums

SSIS and Import/Export (2005)

Executing multiple SSIS packages

Author

Topic

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-04-24 : 11:35:22

I am trying to execute around 3 SSIS packages using Execute package task by having all the 3 in one SSIS package,
I am getting the below error:
Error: Error 0xC001000A while preparing to load the package.
The specified package could not be loaded from the SQL Server database. .

Can I use Execute package task for this purpose??

Thanks!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-24 : 11:45:05

Yup very much. Before that have you loaded you package to msdb folder of SQL Server? If not using SQL Server Management Studio connect to Integration Services in your server and expand folders in object explorer and select msdb and export the 3 called packages to msdb. Then try executing your SSIS package.

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-04-24 : 14:33:31

I am doing the follow:
1. Right click on MSDB
2. Import package
Inside Import package window:
Package location: SQL Server
Server: servername
authentication: windows authen
Package path: \\server\C$\folder1\SSIS Packages\folder2
Import package as:
Package name: package.dtsx
Below is the error I am getting:
TITLE: Import Package
------------------------------
Cannot find folder "\\server\C$\folder1\SSIS Packages\folder2".

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-25 : 11:44:02

Is the server & folder path correct? Try loading it after copying to local location.

sqlserverdeveloper
Posting Yak Master

243 Posts

Posted - 2008-04-25 : 14:51:45

I was able to load the package's into the MSDB folder of SQL Server. Then I went back to the Visual studio and open the Final package which has those 3 packages in it and then when I executed this Final package I got the below error:
Error: Error 0xC001000A while preparing to load the package. The specified package could not be loaded from the SQL Server database. .
Task Execute Package packagename failed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources