I have a datasource that needs to be created using variables but the "XML File from Variable" doesn't recognise the source when using the variables. If you hard code the path in the variable it works OK. All ideas gratefully received. The hardcoded path that works is: > d:\\DropBox\\In\\AA.XMLProcessing ![alt text] :
http://ask.sqlservercentral.com/storage/temp/162-Variables.jpg If this isn't possible does anyone have any workarounds? Many thanks
You actually will need to build this as an expression within the property window of the "XMLSource" variable. Your expression should look like:
@[user::SourceDir] + "\\\\" + @[User::FileName] + ".XMLProcessing" Then ensure you have the EvalueAsExpression property set to true for your "XMLSource" variable.