Delayed Validation on an SSIS "XML Task" isn't working

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
In SSIS I am using an "XML Task" to do an XSLT trasform. But the source document is defined at runtime, so my Input is a "File Connection", but the "Source" is defined by an expression. The output is to a variable, and the "Second Operand" is an XSLT script
supplied as "Direct Input". I also have DelayValidation set to TRUE so it should not complain about the fact that my source data file doesnt exist until runtime (a technique Ive used for many other SSIS tasks and packages).
But when I attempt to save the DTSX package I get the following error/warning:-
<br/>
TITLE: Microsoft Visual Studio<br/>
------------------------------<br/>
Nonfatal errors occurred while saving the package:<br/>
Error at ImportLocationStoreXML: The connection "C:MyProjectBatchDataInlocationstore.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
Error at ImportLocationStoreXML: The connection "C:MyProjectBatchDataInlocationstore.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
Error at ImportLocationStoreXML: The connection "C:MyProjectBatchDataInlocationstore.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
------------------------------<br/>
BUTTONS:<br/>
OK<br/>
------------------------------
<br/>
Then when I run it I get the following set of errors:-
<br/>
Started: 11:54:27 AM<br/>
Error: 2011-05-09 11:54:27.70<br/>
Code: 0xC001000E<br/>
Source: <br/>
Description: The connection "C:MyProjectBatchDataInlocationstore.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
End Error<br/>
Error: 2011-05-09 11:54:27.94<br/>
Code: 0xC001000E<br/>
Source: ImportLocationStoreXML <br/>
Description: The connection "C:MyProjectBatchDataInlocationstore.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
End Error<br/>
Error: 2011-05-09 11:54:27.98<br/>
Code: 0xC001000E<br/>
Source: ImportLocationStoreXML <br/>
Description: The connection "C:MyProjectBatchDataInlocationstore20110414-113239-322.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
End Error<br/>
Error: 2011-05-09 11:54:28.00<br/>
Code: 0xC001000E<br/>
Source: ImportLocationStoreXML <br/>
Description: The connection "C:MyProjectBatchDataInlocationstore20110414-113239-322.xml" is not found. This error is thrown by Connections collection when the specific connection element is not found.<br/>
End Error
<br/>
This is strange because,<br/>
1. The file C:MyProjectBatchDataInlocationstore.xml is what my source Expression evaluates to during development. And this file does not exist - but DelayValidation should prevent this being flagged as an error.<br/>
2. The file C:MyProjectBatchDataInlocationstore20110414-113239-322.xml is what my source Expression evaluates to at runtime. And this file DOES exist, even though the logfile says it doesnt!
Any suggestions?
Thanks



<hr class="sig Andy Abel

View the full article
 
Back
Top