Execute Package Tasks fails with "The system cannot find the path specified"

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Execute Package Tasks fails with "The system...

Execute Package Tasks fails with "The system cannot find the path specified"

Rate Topic

Display Mode

Topic Options

Author

Message

gideon.kahl

Posted Wednesday, February 04, 2009 7:07 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, November 17, 2011 2:30 AM
Points: 18, Visits: 987

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

vishal.gamji

Posted Wednesday, February 04, 2009 7:55 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:20 PM
Points: 536, Visits: 476

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

gideon.kahl

Posted Wednesday, February 04, 2009 8:01 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, November 17, 2011 2:30 AM
Points: 18, Visits: 987

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

oggie23

Posted Thursday, March 29, 2012 10:20 AM

Forum 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 »

Permissions