<div>
Does this link help you?<br />
<br />
<a href="http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/" rel="ugc">http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/</a>
</div>


Does this link help you?

http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/ [http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/]

<div>
I am not sure how this would help. &nbsp;I believe We have SQL2008 and I am using vs2005 to build the report. &nbsp;I don't have access to upgrade or do anything on the server. &nbsp;Isn't there a way to manipulate or strip the field?
</div>


I am not sure how this would help.  I believe We have SQL2008 and I am using vs2005 to build the report.  I don't have access to upgrade or do anything on the server.  Isn't there a way to manipulate or strip the field?

<div>
<div class="content wysiwyg-content">
Hi, I have a field returned in a report that points to =Fields!Comments.Value<br />
This is a multiline field from Sharepoint. &nbsp;When it is returned, the values are wrapped by &lt;div&gt; &lt;/div&gt; Respectively if there is a value. eg.<br />
<br />
&lt;div&gt;This is a comments test.&lt;/div&gt;<br />
Is there a way to strip the &lt;div&gt;/&lt;div&gt; to retun only what inbetween?<br />
eg. This is a comments test.
</div>
</div>


Hi, I have a field returned in a report that points to =Fields!Comments.Value
This is a multiline field from Sharepoint.  When it is returned, the values are wrapped by <div> </div> Respectively if there is a value. eg.

<div>This is a comments test.</div>
Is there a way to strip the <div>/<div> to retun only what inbetween?
eg. This is a comments test.

Strip delimiters from Comments field

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.