Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Executing multiple SSIS packages Expand / Collapse
Author
Message
Posted Thursday, April 24, 2008 9:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
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!!
Post #490045
Posted Thursday, April 24, 2008 1:18 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
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".
Post #490256
Posted Wednesday, August 24, 2011 7:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 8:27 AM
Points: 9, Visits: 56
You should check this post.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/72e961fb-2bc8-4e34-9b2b-9e5b31592ebe/
Post #1164671
Posted Wednesday, August 24, 2011 7:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:39 AM
Points: 5,167, Visits: 12,017
Amar009 (8/24/2011)
You should check this post.

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


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



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1164677
Posted Wednesday, August 24, 2011 8:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 8:27 AM
Points: 9, Visits: 56
Am sorry.. . Saw the last login instead...!! Came back after a long time.
Post #1164733
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse