SSIS Variable is Empty

Posted by Vuyiswamb under Sql Server on 11/3/2009 | Views : 2882 | Status : [Member] [MVP] [Administrator] | Replies : 1
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

Thank you for posting at Dotnetfunda
[Administrator]



Responses

Posted by: Vuyiswamb on: 11/3/2009 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
The Resolution to this was to set the Result set to XML.
What i have done incorrect is that i had used the Parameter Mapping. (It is used in case u are passing any parameters.)
i needed to set the Result set.
1. Goto the ResultSet tab on the left of the EST editor.
2. click the ADD button.
3. Set the ResultName as 0 (numeric zero)
4. Map my variable XML_VAR.
5. Execute the package.

Sometimes i get Stuck too :)

Thank you for posting at Dotnetfunda
[Administrator]

Vuyiswamb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response