Foreach ADO Enumerator?

my setting in foreach component like below shown

Enumerator: Foreach ADO Enumerator

ADO Object source variable: user::strsql

strsql like "select distinct name from table"

Enumeration mode: Rows in the first table

my goal: transform data according to the distinct every name

however execute error

prompt: Variable "User::strsql" does not contain a valid data object

pls help,thanks in advance

The foreach ADO Enum, needs and OBJECT type.

You need to create a Execute SQL Task with the SQL you want, then asign the return to the object variable. Then use the object as the ADO Object.

See this example: http://blogs.conchango.com/jamiethomson/archive/2005/07/04/1748.aspx

force protocol encryption on the server network utility registry setting

Does anyone know when the registry key is to unset the "force protocol
encryption" on the server network utiltiy is?
Thanks
Seems to be (for a default instance):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib
Key name "Encrypt" (REG_DWORD). Value 1 seems to be enforced. 1 means not enforced. Reg key didn't
exist until I enforced encryption.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joel" <nowhere@.nowhere.com> wrote in message news:uEWoaqR7FHA.3864@.TK2MSFTNGP10.phx.gbl...
> Does anyone know when the registry key is to unset the "force protocol encryption" on the server
> network utiltiy is?
> Thanks
>
|||Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWInJ7R7FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Seems to be (for a default instance):
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\SuperSocketNetLib
> Key name "Encrypt" (REG_DWORD). Value 1 seems to be enforced. 1 means not
> enforced. Reg key didn't exist until I enforced encryption.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Joel" <nowhere@.nowhere.com> wrote in message
> news:uEWoaqR7FHA.3864@.TK2MSFTNGP10.phx.gbl...
>

force protocol encryption on the server network utility registry setting

Does anyone know when the registry key is to unset the "force protocol
encryption" on the server network utiltiy is?
ThanksSeems to be (for a default instance):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\SuperSocketNet
Lib
Key name "Encrypt" (REG_DWORD). Value 1 seems to be enforced. 1 means not en
forced. Reg key didn't
exist until I enforced encryption.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joel" <nowhere@.nowhere.com> wrote in message news:uEWoaqR7FHA.3864@.TK2MSFTNGP10.phx.gbl...[
vbcol=seagreen]
> Does anyone know when the registry key is to unset the "force protocol enc
ryption" on the server
> network utiltiy is?
> Thanks
>[/vbcol]|||Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWInJ7R7FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Seems to be (for a default instance):
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MS
SQLServer\MSSQLServer\SuperSocketN
etLib
> Key name "Encrypt" (REG_DWORD). Value 1 seems to be enforced. 1 means not
> enforced. Reg key didn't exist until I enforced encryption.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Joel" <nowhere@.nowhere.com> wrote in message
> news:uEWoaqR7FHA.3864@.TK2MSFTNGP10.phx.gbl...
>

force protocol encryption on the server network utility registry setting

Does anyone know when the registry key is to unset the "force protocol
encryption" on the server network utiltiy is?
ThanksSeems to be (for a default instance):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
Key name "Encrypt" (REG_DWORD). Value 1 seems to be enforced. 1 means not enforced. Reg key didn't
exist until I enforced encryption.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Joel" <nowhere@.nowhere.com> wrote in message news:uEWoaqR7FHA.3864@.TK2MSFTNGP10.phx.gbl...
> Does anyone know when the registry key is to unset the "force protocol encryption" on the server
> network utiltiy is?
> Thanks
>|||Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uWInJ7R7FHA.3684@.TK2MSFTNGP12.phx.gbl...
> Seems to be (for a default instance):
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
> Key name "Encrypt" (REG_DWORD). Value 1 seems to be enforced. 1 means not
> enforced. Reg key didn't exist until I enforced encryption.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Joel" <nowhere@.nowhere.com> wrote in message
> news:uEWoaqR7FHA.3864@.TK2MSFTNGP10.phx.gbl...
>> Does anyone know when the registry key is to unset the "force protocol
>> encryption" on the server network utiltiy is?
>> Thanks
>