"Awi Ktir" <awi@ktir.net> wrote in message
news:exq%23zH$OHHA.3668@TK2MSFTNGP02.phx.gbl...
>I have a package that has config file.
> there is a variable in the package that should come from the config file
> and be fed to a simple update stmt.
> the connection is ADO (not ADO.net).
>
> variable is user::mg_id
> the config file has the name or the variable and the value in it.
> the package has the variable.
>
> the update stmt should update a col to the value of the variable.
> update tblname set col_name = (value of the variable mg_id)..
>
> how to do that? what are the place holders and where to put what.
>
> the task does not accept the SQL stmt unless we declare the @param inside
> it and i did the mapping between @param and the variable user::mg_id in
> but it still updates everything to NULL.
>
> thanks.
>
>
>
>

"Awi Ktir" <awi@ktir.net> wrote in message
news:exq#zH$OHHA.3668@TK2MSFTNGP02.phx.gbl:

> I have a package that has config file.
> there is a variable in the package that should come from the config file and
> be fed to a simple update stmt.
> the connection is ADO (not ADO.net).
>
> variable is user::mg_id
> the config file has the name or the variable and the value in it.
> the package has the variable.
>
> the update stmt should update a col to the value of the variable.
> update tblname set col_name = (value of the variable mg_id)..
>
> how to do that? what are the place holders and where to put what.
>
> the task does not accept the SQL stmt unless we declare the @param inside it
> and i did the mapping between @param and the variable user::mg_id in but it
> still updates everything to NULL.
>
> thanks.