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: Sunday, December 7, 2014 9:00 AM
Points: 264, Visits: 1,513
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: Sunday, December 7, 2014 9:00 AM
Points: 264, Visits: 1,513
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 @ 2:15 AM
Points: 5,317, Visits: 12,354
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.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
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