Executing multiple SSIS packages

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  April 24, 2008 at 9:33 am

  #121493

  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!!

• Mh-397891

  SSCertifiable

  Points: 6704

  More actions

  April 24, 2008 at 1:18 pm

  #806853

  Since the SSIS packages are not in MSDB, 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".

• Amar009

  Mr or Mrs. 500

  Points: 552

  More actions

  August 24, 2011 at 7:32 am

  #1372561

  You should check this post.

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/72e961fb-2bc8-4e34-9b2b-9e5b31592ebe/

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  August 24, 2011 at 7:40 am

  #1372567

  Amar009 (8/24/2011)

  ---

  You should check this post.

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/72e961fb-2bc8-4e34-9b2b-9e5b31592ebe/%5B/quote%5D

  ...and you should check the date of the original posts

  ---

• Amar009

  Mr or Mrs. 500

  Points: 552

  More actions

  August 24, 2011 at 8:38 am

  #1372620

  Am sorry.. . Saw the last login instead...!! Came back after a long time.