|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:28 PM
Points: 261,
Visits: 1,492
|
|
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!!
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 2:28 PM
Points: 261,
Visits: 1,492
|
|
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".
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, August 21, 2012 5:31 AM
Points: 8,
Visits: 52
|
|
You should check this post.
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/72e961fb-2bc8-4e34-9b2b-9e5b31592ebe/
|
|
|
|
|
SSCarpal Tunnel
       
Group: General Forum Members
Last Login: Today @ 1:17 PM
Points: 4,234,
Visits: 9,470
|
|
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:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Tuesday, August 21, 2012 5:31 AM
Points: 8,
Visits: 52
|
|
Am sorry.. . Saw the last login instead...!! Came back after a long time.
|
|
|
|