"salim" <salimcharbel@wanadoo.fr> wrote in message
news:998943e2.0404211208.1c4789f4@posting.google.com...
> i'm trying to use in a DTS package the Dynamic properties task, i
> tried the ini file option IT WORKS and i'm really satisfied, but
> others are not, so i tried to use the sql query option and i have an
> error which is
> "the database is read only or the object does not exist" (sorry
> translated from french)
> i checked the database properties and i'm sure that the table exists
> and the query returns one value
> HELP i have to finish it before this friday
> thanks for ur help

"ss cha" <salimcharbel@hotmail.com> wrote in message
news:er97%23q%23JEHA.3084@TK2MSFTNGP11.phx.gbl...
> First of all thank u for the answer
> i'll try to explain the prob: i'm importinf from an excel file to a SQl
> database with a DTS package, i wanted to specify the way to the file
> (c:\hgg.xls)in a SQL table.
> so in the package i added a DP, i specified the connexion i'm using and
> for value i choosed query and than wrote this query:
> select value from database.user.table where id =11
> when i press the buttom refresh (actualiser in french version)the error
> appears, i tried many queries just to try if the prob appears only from
> my DB the same message appears "the database is read only or the object
> does not exist"
> i tried the option .ini file and it worked when i pressed the buttom
> refresh the value i wanted appeared in the case value of the DP
>
> thanks again for ur help
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!