Showing posts with label design. Show all posts
Showing posts with label design. Show all posts

Monday, March 19, 2012

Add txt file in report

I want to know with expression that how to add a txt file in report design so
when report is viewed text of txt file can also be viewed in Browser.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200704/1On Apr 12, 12:53 am, "asharma via SQLMonster.com" <u8315@.uwe> wrote:
> I want to know with expression that how to add a txt file in report design so
> when report is viewed text of txt file can also be viewed in Browser.
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200704/1
As far as I know, there is not a way to do this directly; however, you
could try converting the text file to an HTML page and using the Jump
to URL property of a control to point to the HTML file on the Web
Server. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Sunday, March 11, 2012

Add services to SSIS IServiceProvider model?

Is there any mechanism for being able to add custom services into the SSIS service provider model so that they can be used by components at design and runtime? i.e. if I can currently access service implementations such as the IDtsConnectionService from the Initialize method of a custom component (or in a UI type editor), is there a way to add a service of my own?

Thanks

Interesting - we've never thought about this. What kind of services do you plan to add there? Note that the services are for design time only, they are no available at runtime.|||

Thankyou for the response - actually design-time only services would still be useful in this case - I'm writing custom components against a JD Edwards Oracle database, but I'm having to interpret the data dictionary schema for business users to assist them in writing their queries (it has to be available offline).

I currently have metadata available to the components so that they can present meaningful field information to users before it is mapped onto the underlying schema, but it would be extremely useful if my components could utilise a service that wrapped this metadata functionality for them.