February 4, 2009 at 7:07 am
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?
February 4, 2009 at 7:55 am
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?
February 4, 2009 at 8:01 am
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.
March 29, 2012 at 10:20 am
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!
February 26, 2018 at 2:40 pm
Does anyone know of a solution to this? I'm currently experiencing the same issue. Any advice would be greatly appreciated. Thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply