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

What returns that error? The Dynamic Properties task or the thing that is
set by this property.? What is the Query?

If I set the Pubs DB to RO and populate an ExecuteSQL task SQLStatement
property through a DP task then i have no problems. Remember that if you are
looking to populate the statement itself then the type of asignment should
be a "constant" unless you hold SQL queries in tables.

It could just be that you have misspelled something



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"salim" <salimcharbel (AT) wanadoo (DOT) fr> wrote

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!

It works for me.

What SP level are you on?

select @@version

Make sure the connection you specify ni the Query of the DP task is poing to
the correct package connection i.e. not at your spreadsheet.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"ss cha" <salimcharbel (AT) hotmail (DOT) com> wrote