Executing multiple SSIS packages

Last Post 25 Apr 2008 11:56 AM by sqlserverdeveloper. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sqlserverdeveloper
New Member
New Member

--
24 Apr 2008 02: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??

Thanks!!
sqlserverdeveloper
New Member
New Member

--
25 Apr 2008 11:56 AM
I got it, thanks, actuallu the package location should be file system. Thanks for your response.
You are not authorized to post a reply.

Acceptable Use Policy