SSIS XML Data Source and variables

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

If this isn't possible does anyone have any workarounds?

Many thanks

Variables.jpg (21.0 kB)

asked Apr 12 '12 at 04:04 PM in Default

Mrs_Fatherjack
4.6k ● 48 ● 53 ● 61

just a thought - variable scope is a pain in SSIS, are all the variable declared in the right places?

Apr 12 '12 at 04:07 PM Fatherjack ♦♦

All variables in the package scope so should be OK. I've been burnt by that before. :)

Apr 12 '12 at 04:10 PM Mrs_Fatherjack

(comments are locked)

1 answer:

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.

answered Apr 12 '12 at 04:40 PM

Shawn_Melton
4.7k ● 13 ● 18 ● 27

@Shawn Melton +1. This should do it. Although I have to edit your answer to show double backslashes (put 4 backslashes to make it work) :) The same way SSIS works ;)

Apr 13 '12 at 06:27 AM Usman Butt

Awesome, that works perfectly. Many thanks.

Apr 13 '12 at 07:35 AM Mrs_Fatherjack

(comments are locked)