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

Execute Package Tasks fails with "The system cannot find the path specified" Expand / Collapse
Author
Message
Posted Wednesday, February 4, 2009 7:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 2:08 AM
Points: 18, Visits: 1,032
Hi All

I have a SSIS package (A) which calls a file system SSIS package (B) from an "Execute Package Task". The ConnectionString property for the file connection for (B) is set dynamically from a variable using an expression.

(A) fails with the following error when trying to call (B):
Error: Error 0x80070003 while loading package file "". The system cannot find the path specified. .


I've added a breakpoint on the PreExecute event for B to inspect the value stored in the connection string variable, and everything looks fine. When I take the value from the variable and search for the dtsx file in Windows I find it.

I've done this (calling a file system package from within another package) many times before. I've compared the settings with other packages where I've done this and cannot find a difference. I am sure I am missing something simple. Can anyone help?
Post #649806
Posted Wednesday, February 4, 2009 7:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, March 16, 2014 10:26 AM
Points: 536, Visits: 516
Is your path coming from a package configuration? If you do have it as a pkg config, Did u restart BIDS after u added this variable?
Post #649851
Posted Wednesday, February 4, 2009 8:01 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 2:08 AM
Points: 18, Visits: 1,032
No, the path is set with an "Execute SQL Task". The variable is set to the correct path and the path is valid. It appears that the ConnectionString property for the file connection manager does not get set.
Post #649860
Posted Thursday, March 29, 2012 10:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 2:23 PM
Points: 1, Visits: 14
Did you solve this issue?

I'm having the same problem. The ConnectionString property of the FILE Connection Manager is set via an Expression, but, although the variable I'm using for the expression has the correct value, the ConenctionString property of the Connection Manager is still empty!
Post #1275211
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse