SSIS Variable is Empty

Expand Post »

Good Day all

i have created a Global Variable as depicted in the following Pic

http://www.tiyaneproperties.co.za/SSIS/pic1.JPG

The Following Screen-shot shows how i created my Variable and its Properties

http://www.tiyaneproperties.co.za/SSIS/pic2.JPG

and the Following Screen-shot shows the Script Editor Properties

http://www.tiyaneproperties.co.za/SSIS/pic3.JPG

and the Last pic is the code that write to the XML File

http://www.tiyaneproperties.co.za/SSIS/pic4.JPG

The Variable comes back empty and at the end the file comes back empty. So i added a if statement as you can see to make sure that the part that write to the file has no problems.

Thank you

Similar Threads

pass variable from php to javascript in PHP
Hiding a div if a variable is empty in JavaScript / DHTML / AJAX
Undefined variable in PHP
Code to say Empty date in Visual Basic 4 / 5 / 6
Couple of questions in PHP

vuyiswamb

Reputation Points: 31

Solved Threads: 14

Posting Whiz

Offline

310 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Union identical tables in one view

Next Thread in MS SQL Forum Timeline: SSRS delete blank rows

DaniWeb Message

Cancel Changes

User Name
Password