Executing multiple SSIS packages

Last Post 25 Apr 2008 10:56 AM by sqlserverdeveloper. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

24 Apr 2008 01:38 PM
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. .

Then I did the following:
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".

Can I use Execute package task for this purpose??

New Member
New Member

25 Apr 2008 10:56 AM
I got it, thanks, actuallu the package location should be file system. Thanks for your response.

Acceptable Use Policy