Showing posts with label possibility. Show all posts
Showing posts with label possibility. Show all posts

Monday, March 26, 2012

Running a DTS with parameters

Hi
Does anyone know if there is a possibility to run a DTS with parameters ?
David GreenbergDavid Greenberg wrote:

Quote:

Originally Posted by

Hi
Does anyone know if there is a possibility to run a DTS with parameters ?
David Greenberg


Yes. Usually parameters are passed via global variables when the
package is executed. For example using the dtsrun utility from the
command line, or from an Execute Package task or using the COM Package
object.

Some examples at:
http://www.sqldts.com/default.aspx?104
--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/...US,SQL.90).aspx
--

Tuesday, February 21, 2012

RTF or HTML Textbox

Is there a possibility with the final Reporting Services 2008 to have
textboxes with RTF or HTML facilities? I didn't found something in the
November CTP.
If yes, will it be possible to display such a report with the Report Viewer
in a WindowsForm as a local report?
Thanks
Peterhttp://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx
This report mentions rich text but that is all it does.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pan" <pan@.discussions.microsoft.com> wrote in message
news:CE2773B3-731A-403A-BD7F-94C5D9C30BB0@.microsoft.com...
> Is there a possibility with the final Reporting Services 2008 to have
> textboxes with RTF or HTML facilities? I didn't found something in the
> November CTP.
> If yes, will it be possible to display such a report with the Report
> Viewer
> in a WindowsForm as a local report?
> Thanks
> Peter|||I am pretty sure it is the second but I cannot find a link to confirm that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"pan" <pan@.discussions.microsoft.com> wrote in message
news:B41A760B-8916-4289-A0DB-226B97D9521E@.microsoft.com...
> Thanks a lot. Sometimes it's difficult to find documents. Information on
> SQL
> 2008 is quite hidden...
> For me, it's not so clear if the doc means "Rendering of a complete report
> as an RTF doc" or that what I (and many others) need: "Display data from
> the
> database that is in RTF format in a text box"
> The first option, we had already with version 2005. The second is MISSING
> since a very long time!
>
> "Bruce L-C [MVP]" wrote:
>> http://www.microsoft.com/sql/techinfo/whitepapers/sql_2008_ssrs.mspx
>> This report mentions rich text but that is all it does.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "pan" <pan@.discussions.microsoft.com> wrote in message
>> news:CE2773B3-731A-403A-BD7F-94C5D9C30BB0@.microsoft.com...
>> > Is there a possibility with the final Reporting Services 2008 to have
>> > textboxes with RTF or HTML facilities? I didn't found something in the
>> > November CTP.
>> > If yes, will it be possible to display such a report with the Report
>> > Viewer
>> > in a WindowsForm as a local report?
>> >
>> > Thanks
>> > Peter
>>