none
Error when a variable be set "null" value by "Foreach ADO Enumerator". RRS feed

  • 问题

  • I'm using SSIS 2005 now.

    In the "Foreach Loop Container", when a variable be set "null" value by "Foreach ADO Enumerator", it will run wrong.

    How to solve it?

    2011年6月28日 13:39

全部回复

  • Got any error? Can you post it?
    2011年6月28日 14:07
  • The "Varible" in Foreach ADO enumerator will be used to create the connection string, the value is mandatory, shouldn't be left as "null"
    2011年6月28日 15:38
    版主
  • The "Varible" in Foreach ADO enumerator will be used to create the connection string, the value is mandatory, shouldn't be left as "null"


    I mean that I set a variable(Object type) in ADO object source variable box, and this variable(Object type) like a table, some cell will be null. When I set the value of this Object into some variables, it runs wrong if any variable be set null value.

    How to allow any variable be set null value?

    2011年6月29日 1:09