| | |
SSIS Variable is Empty
Please support our MS SQL advertiser: Intel Parallel Studio Home
![]() |
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
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
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
![]() |
Similar Threads
- Hiding a div if a variable is empty (JavaScript / DHTML / AJAX)
- Undefined variable (PHP)
- Code to say Empty date (Visual Basic 4 / 5 / 6)
- pass variable from php to javascript (PHP)
- Couple of questions (PHP)
- hide link if variable is empty (JSP)
- Print 5 records per table row (see script) (Perl)
- C++ CString Class Help! (C++)
Other Threads in the MS SQL Forum
- Previous Thread: Union identical tables in one view
- Next Thread: SSRS delete blank rows
| Thread Tools | Search this Thread |





