"include link" from database always errors

I have a data driven subscription. I would like to include a link, however,
I want to include the link from the database. So i select the "Get the value
from the database" button under "Include Link". Then i select a field. No
matter what field i select, or what value the field has in it, the
subscription errors out with:
"The value _____ is not valid for setting 'include link' "
Is this another bug? Or are there limitations here that i'm not aware of?
TIA,
BrianI've had this same problem too. Is this a known bug?
Another thing I've noticed about the "include link" setting:
If it is set to "No Value" - the next time the subscription is editted, it
will have reverted back to "Specify a static value"
Also (and I know this has been said before), it would be nice if the Comment
section did not encode HTML tags brackets etc (eg, < is replaced by <). It
is a nuisance having to cut and paste every time. Hopefully this will be
fixed in SP2!
Reference:http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=2ece7ecd-3bb3-48eb-86e9-a1feb0ce6ce2&sloc=en-us

"..Transform requires script Text and Language.." error?

Hi,
I'm trying setup a package to replicate a database table into a another
database's table.
I thought a Data Driven Query Task would work. I got as far as making the
two connections and setting up the Data Driven Query's source SELECT (with
stored procedure I created in the source database) and destination table
under the Bindings tab.
However, when I run the task I get the error below
"ActiveX Scripting Transform requires script Text and Language and at least
one Phase function to be specified."
When I preview the data in under the task's Source tab, I see data AND the
destination table gets created but not data gets transfered. Can someone
please help on what this error means?
Also, I eventually want to update this destination table with several other
subsequent queries from other databases in order to conslidate related data
into one large reporting table but I have to get the initial population of
data to work first. This will be refreshed daily
Does this approach/package task seem to be applicable?
Thanks, Dave.
Dave,
you'd be best off posting in the separate DTS discussion group.
Rgds,
Paul Ibison
|||Open up your package, save it as a bas file and post it here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||I have the exact same problem as this guy. Could you please help?
thanks
marlene
url:http://www.ureader.com/msg/1156295.aspx