SSIS XML Data Source and variables

Question

question

Mrs_Fatherjack asked Apr 12, '12

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][1] [1]: http://ask.sqlservercentral.com/storage/temp/162-Variables.jpg If this isn't possible does anyone have any workarounds? Many thanks

ssis xml sourcevariable

Variables.jpg (20.5 KiB)

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack ♦♦ commented · Apr 12, 2012 at 04:07 PM

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

0 ·

Mrs_Fatherjack commented · Apr 12, 2012 at 04:10 PM

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

0 ·

Answer 1 · 2012-04-12T16:40:47Z

Shawn_Melton answered Apr 12, '12

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.

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt commented · Apr 13, 2012 at 06:27 AM

@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 ;)

1 ·

Mrs_Fatherjack commented · Apr 13, 2012 at 07:35 AM

Awesome, that works perfectly. Many thanks.

0 ·

question