The property XMLDataVariable on the XML Source was empty - Case Foreach Loop Container

I have very simple XML source and OLE DB Source in Foreach Loop Container,
but seem to get error, because XML Source cannot find the XML.

"Error at Data Flow Task. The property XMLDataVariable on the XML Source was empty"

Variables:
FileExtention = *.xml
FilePath =
FolderPath = C:\Customer\XML

XML Source:
Data Access mode = XML file from variable
Variable name = User::filePath

Foreach Loop Container:
Enumerator = Foreach File Enumerator
Expression-Directory = @User:FolderPath
Expression-FileSpec = @User::FileExtension
Enumerator Folder = C:\Customer\XML
Files = *.xml
Variable mapping-User::FilePath = 0

December 17th, 2013 3:53am

Have you filled the variable (filePath) with a default value? Otherwise the XML Source cannot validate. Alternative is look for a property "DelayValidation". In most cases this is a property of the connection manager, but you're not using one for the xml
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2013 4:19am

I added default filepath+filename to variable FilePath. It works now without error, but in reality I don't know what is exact name of file.

How to make filepath variable for XML Source working without defining default filepath?

December 17th, 2013 5:43am

Try setting the DelayValidation property on the Data Flow Task that contains the xml source.
Free Windows Admin Tool Kit Click here and download it now
December 17th, 2013 5:52am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics