Filter Html tags on Full text Search

I have a Text field in my database that has data along with the HTML tags.
I dont want to search these HTML tags on my FUll text Search.
Example Data
< Font color='red'> Blah</Font>
I want to ignore the font tages on my search.
How do i do it?
save the content in the text data type columns into columns of the image
data type, and use the document type column with a value of htm so that only
the content of these files will be indexed.
"Bruce" <Bruce@.discussions.microsoft.com> wrote in message
news:3BF3659B-E3EB-495F-8D17-75DDD996E323@.microsoft.com...
>I have a Text field in my database that has data along with the HTML tags.
> I dont want to search these HTML tags on my FUll text Search.
> Example Data
> < Font color='red'> Blah</Font>
> I want to ignore the font tages on my search.
> How do i do it?
>
|||Can you please be more elaborate.I am indexing almost 9 columns of Text data
type.How do I save all these columns into columns of the image data type?
How do I use document type columns?
"Hilary Cotter" wrote:

> save the content in the text data type columns into columns of the image
> data type, and use the document type column with a value of htm so that only
> the content of these files will be indexed.
> "Bruce" <Bruce@.discussions.microsoft.com> wrote in message
> news:3BF3659B-E3EB-495F-8D17-75DDD996E323@.microsoft.com...
>
>
|||for the document type column you must
1) ensure you have a column which is char(3) or char(4) and contains the
value htm or .htm
2) store your html content in an image data type column
3) use sp_fulltext_column to specify that the document type is specified in
the document type column you created above in 1)
here is an example
sp_fulltext_column 'MyTable','ImageColumn', 'add', 1033,
'DocumentTypeColumn'
where MyTable is the table you are full text indexing, ImageColumn is a
column of the image datatype, and DocumentTypeColumn is the char(3) or
char(4) column which tells what the native type of the document you are
storing is.
Now, if you also might want to convert your docs to pure text. Using
FiltDump -b myhtmldoc.htm > myhtmldoc.txt is one way of doing it.
To convert your columns from html to text or from the text datatype to image
you should spit them out to the file system, and then convert them and push
them back.
Let me know if you need code samples to do this.
"Bruce" <Bruce@.discussions.microsoft.com> wrote in message
news:604B02B0-2741-402F-AE62-318452B9BDF0@.microsoft.com...
> Can you please be more elaborate.I am indexing almost 9 columns of Text
data[vbcol=seagreen]
> type.How do I save all these columns into columns of the image data type?
> How do I use document type columns?
>
> "Hilary Cotter" wrote:
only[vbcol=seagreen]
tags.[vbcol=seagreen]
|||Hilary,
"Now, if you also might want to convert your docs to pure text. Using
FiltDump -b myhtmldoc.htm > myhtmldoc.txt is one way of doing it."
Is the use of FiltDump in the above scenario a violation of Microsoft's
licensing agreement?
Thanks,
John
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:uIB1eqrtEHA.2596@.TK2MSFTNGP10.phx.gbl...
> for the document type column you must
> 1) ensure you have a column which is char(3) or char(4) and contains the
> value htm or .htm
> 2) store your html content in an image data type column
> 3) use sp_fulltext_column to specify that the document type is specified
in
> the document type column you created above in 1)
> here is an example
> sp_fulltext_column 'MyTable','ImageColumn', 'add', 1033,
> 'DocumentTypeColumn'
>
> where MyTable is the table you are full text indexing, ImageColumn is a
> column of the image datatype, and DocumentTypeColumn is the char(3) or
> char(4) column which tells what the native type of the document you are
> storing is.
> Now, if you also might want to convert your docs to pure text. Using
> FiltDump -b myhtmldoc.htm > myhtmldoc.txt is one way of doing it.
> To convert your columns from html to text or from the text datatype to
image
> you should spit them out to the file system, and then convert them and
push[vbcol=seagreen]
> them back.
> Let me know if you need code samples to do this.
>
> "Bruce" <Bruce@.discussions.microsoft.com> wrote in message
> news:604B02B0-2741-402F-AE62-318452B9BDF0@.microsoft.com...
> data
type?[vbcol=seagreen]
image[vbcol=seagreen]
that
> only
> tags.
>
|||That's in interesting question. I'll have to check into it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OEpwKoFuEHA.2624@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Hilary,
> "Now, if you also might want to convert your docs to pure text. Using
> FiltDump -b myhtmldoc.htm > myhtmldoc.txt is one way of doing it."
> Is the use of FiltDump in the above scenario a violation of Microsoft's
> licensing agreement?
> Thanks,
> John
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:uIB1eqrtEHA.2596@.TK2MSFTNGP10.phx.gbl...
> in
> image
> push
Text[vbcol=seagreen]
> type?
> image
> that
HTML
>
|||Yes, as you had indicated in the past that any such use was not allowed by a
non-publicly available license policy for these files in another thread. If
you or Microsoft would make this licensing policy public, then there would
be less confusion on this issue.
Best Regards,
John
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#SNgrgWuEHA.3320@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> That's in interesting question. I'll have to check into it.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:OEpwKoFuEHA.2624@.TK2MSFTNGP11.phx.gbl...
the[vbcol=seagreen]
specified[vbcol=seagreen]
a[vbcol=seagreen]
are
> Text
> HTML
>
|||Specifically what I said in the past was that I had been advised by
Microsoft that you could not use the word breakers for your own purposes, ie
to roll your own hit highlighting solution.
Filtdump may be another matter, as it is a diagnostic tool.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:%2344qClXuEHA.2828@.TK2MSFTNGP12.phx.gbl...
> Yes, as you had indicated in the past that any such use was not allowed by
> a
> non-publicly available license policy for these files in another thread.
> If
> you or Microsoft would make this licensing policy public, then there would
> be less confusion on this issue.
> Best Regards,
> John
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:#SNgrgWuEHA.3320@.TK2MSFTNGP15.phx.gbl...
> the
> specified
> a
> are
>
|||You also "generalized" response to include ALL .dll and .exe files in
addition to the wordbreaker dll files, if memory servers me correctly. I
also asked you (or Microsoft) at that time to make public (and now again)
the specific licensing policy from Microsoft that you are referring to. If
it is a secret or under NDA, then how can anyone judge whether or not he or
she is violating a non-public licensing agreement.
Best Regards,
John
PS: Feel free to contact me off-line.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eyNhvefuEHA.3456@.TK2MSFTNGP10.phx.gbl...
> Specifically what I said in the past was that I had been advised by
> Microsoft that you could not use the word breakers for your own purposes,
ie[vbcol=seagreen]
> to roll your own hit highlighting solution.
> Filtdump may be another matter, as it is a diagnostic tool.
>
> "John Kane" <jt-kane@.comcast.net> wrote in message
> news:%2344qClXuEHA.2828@.TK2MSFTNGP12.phx.gbl...
by[vbcol=seagreen]
would[vbcol=seagreen]
Microsoft's[vbcol=seagreen]
contains[vbcol=seagreen]
is[vbcol=seagreen]
Using[vbcol=seagreen]
of[vbcol=seagreen]
data[vbcol=seagreen]
[vbcol=seagreen]
the
>
|||Please review the pertinent posts:
http://groups.google.com/groups?hl=e...ver .fulltext
http://groups.google.com/groups?hl=e...ver .fulltext
I am not trying to hide anything and AFAIK the communication was not under
NDA. I do not have the communication I had with the Microsoft developer, nor
do I have the response I received from the link I posted as I posted above.
The link I posted is regarding distributing dlls and exes, as you correctly
point out. When I asked another question about tapping into services exposed
by another Microsoft product for my commercial use, I was directed to this
link by a PSS engineer who explained this was the forum to ask these
questions to.
I'll follow up on filtdump and post back here with the response I get. I
will ask that it can be made public.
Please stop mischaracterizing what I say, or check the original posts before
commenting on them.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:#dD0fKhuEHA.2632@.TK2MSFTNGP10.phx.gbl...
> You also "generalized" response to include ALL .dll and .exe files in
> addition to the wordbreaker dll files, if memory servers me correctly. I
> also asked you (or Microsoft) at that time to make public (and now again)
> the specific licensing policy from Microsoft that you are referring to. If
> it is a secret or under NDA, then how can anyone judge whether or not he
or[vbcol=seagreen]
> she is violating a non-public licensing agreement.
> Best Regards,
> John
> PS: Feel free to contact me off-line.
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:eyNhvefuEHA.3456@.TK2MSFTNGP10.phx.gbl...
purposes,[vbcol=seagreen]
> ie
allowed[vbcol=seagreen]
> by
thread.[vbcol=seagreen]
> would
Using[vbcol=seagreen]
> Microsoft's
> contains
ImageColumn[vbcol=seagreen]
> is
char(3)[vbcol=seagreen]
you[vbcol=seagreen]
> Using
datatype[vbcol=seagreen]
them[vbcol=seagreen]
> of
> data
of[vbcol=seagreen]
htm[vbcol=seagreen]
> the
Search.
>

Filter for WordML vs Filter for XML vs Filter for Text

We currently are saving WordML (Word 2003's XML format rather than binary
format) docs into a column of our SQL Server 2005 database and full text
indexing on it. Works okay, but not great. For example, all the XML tags
are indexed... so you find many words that are not in the document (from the
user persepctive).
The fix for that is clear... use an XML filter. (Though how to do that is
not so clear... we tried moving the WordML from a Text column to an XML
column, but it gives errors on illegal characters in the Word doc.)
However, it would seem that even an XML filter will not do nearly as well as
a filter designed for WordML.
Can anyone point me to a WordML full-text-search filter for SQL Server
2005?
Thanks,
Brian
Have you tried storing them as doc's in varbinary (max) or image columns and
indexing them with the Word iFilter.
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
"Brian" <TargetedConvergence@.newsgroup.nospam> wrote in message
news:%23bHGZ5idHHA.4616@.TK2MSFTNGP03.phx.gbl...
> We currently are saving WordML (Word 2003's XML format rather than binary
> format) docs into a column of our SQL Server 2005 database and full text
> indexing on it. Works okay, but not great. For example, all the XML tags
> are indexed... so you find many words that are not in the document (from
> the user persepctive).
> The fix for that is clear... use an XML filter. (Though how to do that is
> not so clear... we tried moving the WordML from a Text column to an XML
> column, but it gives errors on illegal characters in the Word doc.)
> However, it would seem that even an XML filter will not do nearly as well
> as a filter designed for WordML.
> Can anyone point me to a WordML full-text-search filter for SQL Server
> 2005?
> Thanks,
> Brian
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u2u%23lFjdHHA.4656@.TK2MSFTNGP06.phx.gbl...
> Have you tried storing them as doc's in varbinary (max) or image columns
> and indexing them with the Word iFilter.
No, for our app we need to keep them as .xml files, not .doc files.
But we could put the Word .xml file in a varbinary column if there is a
WordML iFilter out there that would act on the .xml file.
Thanks,
Brian
|||Hi Brian,
have you tried storying your WordML files in an a column of type XML? That
should invoke the XML filter.
Best regards,
-Denis.
"Brian" wrote:

> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:u2u%23lFjdHHA.4656@.TK2MSFTNGP06.phx.gbl...
>
> No, for our app we need to keep them as .xml files, not .doc files.
> But we could put the Word .xml file in a varbinary column if there is a
> WordML iFilter out there that would act on the .xml file.
> Thanks,
> Brian
>
>
|||"denistc" <denistc@.discussions.microsoft.com> wrote in message
news:64C9346C-881C-4FC5-928C-1C7751ACECA6@.microsoft.com...
> have you tried storying your WordML files in an a column of type XML? That
> should invoke the XML filter.
Yes, though we've had trouble with some WordML files being rejected.
We've narrowed the issue on that front... any WordML file that has "UTF-8"
in the docheader gets rejected... not sure why though. Also not sure why
Word is creating some files with that encoding. Simply removing the tag
from the docheader (without any other re-encoding) seems to work fine, oddly
enough.
We're a bit nervous to move to the XML column until we understand what
conditions might cause XML to reject a WordML doc coming out of Word...
because without that understanding, we can't be sure it won't happen to our
customers.
Thanks for the suggestion,
Brian
|||"Brian" <TargetedConvergence@.newsgroup.nospam> wrote in message
news:%23OqdVzFgHHA.2396@.TK2MSFTNGP04.phx.gbl...
> Yes, though we've had trouble with some WordML files being rejected.
> We've narrowed the issue on that front... any WordML file that has "UTF-8"
> in the docheader gets rejected... not sure why though. Also not sure why
> Word is creating some files with that encoding. Simply removing the tag
> from the docheader (without any other re-encoding) seems to work fine,
> oddly
> enough.
Haven't done much with WordML myself, but assuming the WordML file has
"UTF-8" in the docheader, I'd be interested to know if it actually is a
UTF-8 file? Or is it possible it is being saved with an incorrect BOM or
invalid (non-UTF-8-encoded) characters in the doc? One of those two would
be my first guess. If so, that might be a bug that needs to be reported to
MS. You might try opening that WordML file in a hex editor to verify what
is actually being stored.

filter expression "LIKE" together with report paramter in RS

Hi there
I have a text field that I would like to filter with a LIKE expression, i.e.:
WHERE (dbo.TBL_SchiBeriBeso.Bemerkung LIKE '%BSK%')
When I use this filter expression in the data query of Reporting Services
everything goes well.
But when I try to use this filter expression in the the report item (table)
I don't get this filter expression working. How do I write this filter
expression in the filter definition in the properties of my table? How
exactly is the right way to write the filter value (BSK) so that the filter
gets me every text field that has BSK somewhere in its contents?
Thanks a lot for your help!
Judith.If you are using a parameter in the Like expression with a wild card try it
like this:
WHERE (dbo.TBL_SchiBeriBeso.Bemerkung LIKE '%' + @.BSK + '%')
"j schuetz" <jschuetz@.discussions.microsoft.com> wrote in message
news:52BC887E-C77F-4FC7-9DDE-ED5B20826EAF@.microsoft.com...
> Hi there
> I have a text field that I would like to filter with a LIKE expression,
> i.e.:
> WHERE (dbo.TBL_SchiBeriBeso.Bemerkung LIKE '%BSK%')
> When I use this filter expression in the data query of Reporting Services
> everything goes well.
> But when I try to use this filter expression in the the report item
> (table)
> I don't get this filter expression working. How do I write this filter
> expression in the filter definition in the properties of my table? How
> exactly is the right way to write the filter value (BSK) so that the
> filter
> gets me every text field that has BSK somewhere in its contents?
> Thanks a lot for your help!
> Judith.|||Thank you for your input. I know now how to solve the problem. The thing is
that the syntax of the filter expression in the table properties window is
different from the syntax in the query.
The value field in the filter expression of the table properties has to have
the following syntax: [= "*" & Parameters!Stichwort.Value & "*"], i.e. the
wild card symbol is * instead of %.
With this syntax the LIKE operator in the table properties window works just
fine!
"Steve Dearman" wrote:
> If you are using a parameter in the Like expression with a wild card try it
> like this:
> WHERE (dbo.TBL_SchiBeriBeso.Bemerkung LIKE '%' + @.BSK + '%')
>
> "j schuetz" <jschuetz@.discussions.microsoft.com> wrote in message
> news:52BC887E-C77F-4FC7-9DDE-ED5B20826EAF@.microsoft.com...
> > Hi there
> >
> > I have a text field that I would like to filter with a LIKE expression,
> > i.e.:
> > WHERE (dbo.TBL_SchiBeriBeso.Bemerkung LIKE '%BSK%')
> >
> > When I use this filter expression in the data query of Reporting Services
> > everything goes well.
> >
> > But when I try to use this filter expression in the the report item
> > (table)
> > I don't get this filter expression working. How do I write this filter
> > expression in the filter definition in the properties of my table? How
> > exactly is the right way to write the filter value (BSK) so that the
> > filter
> > gets me every text field that has BSK somewhere in its contents?
> >
> > Thanks a lot for your help!
> >
> > Judith.
>
>

Filter & *

Hi I am wandering if it is possible to achieve the following:

I am using Reporting Services and Reporting services I got a report with a text parameter.

I would like the user to introduce AA and find the product AA and when he introduces AA* it finds AA, AAD, AAC...

I am doing the following:

Filter([DIM Product].[Product].ALLMEMBERS,

,IIF(INSTR(@.Product, "*") > 0

,[DIM Product].[Product].currentmember.name = Replace(@.Product, "%", "")

,INSTR([DIM Product].[Product].currentmember.name, @.Product)

)

)

The problem ist that the function Replace does not work!

Does someone know how to do it?

I don't think the problem is with the replace, it looks like you have the logic back-to-front, something like the following should get you closer.

Code Snippet

Filter([DIM Product].[Product].ALLMEMBERS,

,IIF(INSTR(@.Product, "*") > 0

,INSTR([DIM Product].[Product].currentmember.name, Replace(@.Product, "*", "")

,[DIM Product].[Product].currentmember.name = @.Product

)

)

However there is an issue that you may or may not be concerned with - If someone types in "A*B" the expression will strip out the "*" and return anything containing "AB".

Another alternative, if you want more sophisticated behaviour might be to look at using a stored procedure. There is a string match example which I wrote in the Analysis Services Stored Procedure project at www.codeplex.com/ASStoredProcedures . I have one in there that reproduces the equivalent of the t-sql LIKE operator.

Filegroup & .NDF Question

This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C68EFB.3FF73960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I change the FILEGROUP on database properties?
SQL Server 2000
I restored one database to create a new database, but the .ndf filegroup = of the restored db has the name of the restored db.
For example;
DB 1 =3D TestDB1.mdf TestINDX1.ndf TestLog1.ldf
Backup this db & restore as Test2
DB 2 =3D TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under = filegroup it has "TestINDX1"
I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just = delete the .NDF & recreate it in EM with the correct filegroup name, but = it keeps telling me I can't drop the .ndf because it is NOT empty.
Where am I going wrong?
Also, am I missing something in my restore? Is there T-Sql in the = restore that designates the .ndf filegroup name & I am missing it?
Any instruction/suggestions will be appreciated!!!
thanx!
--=_NextPart_000_0008_01C68EFB.3FF73960
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How can I change the FILEGROUP on database properties?

SQL Server 2000

I restored one database to create a new = database, but the .ndf filegroup of the restored db has the name of the restored db.
For example;
DB 1 =3D TestDB1.mdf TestINDX1.ndf TestLog1.ldf
Backup this db & restore as = Test2

DB 2 =3D TestDB2.mdf = TestINDX2.ndf (BUT in EM Properties under filegroup it has "TestINDX1"

I tried dbcc shrinkfile(TestIndx2, = emptyfile), so that I could just delete the .NDF & recreate it in EM with the correct = filegroup name, but it keeps telling me I can't drop the .ndf because it is NOT empty.

Where am I going wrong?

Also, am I missing something in my = restore? Is there T-Sql in the restore that designates the .ndf filegroup name = & I am missing it?

Any instruction/suggestions will be appreciated!!!

thanx!

--=_NextPart_000_0008_01C68EFB.3FF73960--Jude,
1 - You can change the name of the physical files during restore operation
using "with move" option.
2 - You can change the logical name of the files, using the statement "alter
database".
alter database northwind
modify file (name = 'northwind', newname = 'northwind1')
exec sp_helpdb northwind
go
See BOL for more info.
AMB
"Jude" wrote:
> How can I change the FILEGROUP on database properties?
> SQL Server 2000
> I restored one database to create a new database, but the .ndf filegroup of the restored db has the name of the restored db.
> For example;
> DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf
> Backup this db & restore as Test2
> DB 2 = TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under filegroup it has "TestINDX1"
> I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just delete the .NDF & recreate it in EM with the correct filegroup name, but it keeps telling me I can't drop the .ndf because it is NOT empty.
> Where am I going wrong?
> Also, am I missing something in my restore? Is there T-Sql in the restore that designates the .ndf filegroup name & I am missing it?
> Any instruction/suggestions will be appreciated!!!
> thanx!
>|||"With Move", I'll look it up in BOL.
thanx!
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:509ED16F-2201-4D31-835E-B5EAE48C53B0@.microsoft.com...
> Jude,
> 1 - You can change the name of the physical files during restore operation
> using "with move" option.
> 2 - You can change the logical name of the files, using the statement
> "alter
> database".
> alter database northwind
> modify file (name = 'northwind', newname = 'northwind1')
> exec sp_helpdb northwind
> go
> See BOL for more info.
>
> AMB
> "Jude" wrote:
>> How can I change the FILEGROUP on database properties?
>> SQL Server 2000
>> I restored one database to create a new database, but the .ndf filegroup
>> of the restored db has the name of the restored db.
>> For example;
>> DB 1 = TestDB1.mdf TestINDX1.ndf TestLog1.ldf
>> Backup this db & restore as Test2
>> DB 2 = TestDB2.mdf TestINDX2.ndf (BUT in EM Properties under filegroup
>> it has "TestINDX1"
>> I tried dbcc shrinkfile(TestIndx2, emptyfile), so that I could just
>> delete the .NDF & recreate it in EM with the correct filegroup name, but
>> it keeps telling me I can't drop the .ndf because it is NOT empty.
>> Where am I going wrong?
>> Also, am I missing something in my restore? Is there T-Sql in the
>> restore that designates the .ndf filegroup name & I am missing it?
>> Any instruction/suggestions will be appreciated!!!
>> thanx!
>>

File Transfer from deskop to PDA thro TCP\IP

Hi All,

I am trying to pass a text file from desktop machine to PDA thro TCP-IP protocols. It follows Server (on desktop machine) and Client (on pda) architecture. File is converted to bytes and will be pushed to network stream. The client on PDA will receive the bytes and store it on queue and writes the file on PDA. The operation is accomplished through threads on both Server and client. Applications are developed on MS Visual Studio 2005 (C#).

For large files like 1024 KB or having lines about 15000, it takes around 15 minutes. Can anyone give a better idea to transmit files from desktop machine to PDA using TCP-IP protocols.

Thanks in advance

Boss

Maybe using compression would help?|||

Hi Erik,

Is it possible to provide more details or links regarding Compression techniques that can be implemented on PDA applications?

Thanks in advance,

Boss

|||There are 3rd party compresion libraries available from various vendors, http://xceed.com/Zip_NET_CF_Intro.html, and http://www.resco.net/developer/zip/default.asp, both allow you to work with streams as well as .zip files.

file system task - Problem

I am using file system task for deletion of text file from a specified folder.

but i want that one text file with name ="ssis.txt" and "ssrs.txt "should not get delete.

Is there any option or any expression that we can set and avoide the deletion of ssis.txt and ssrs.txt and still delete all the remaining all text file from a folder.

Please suggest any method or expression by example.

Sounds like a job for a ForEach loop containing the FileSystem operation, and some task (.Net script?) that compares the file name for the specific iteration of the ForEach loop with the protected tables list, and determines whether to call to File Delete
|||

I just wish to use the file system task and perform this.

Cannt we use some expression infile system task and disable the deletion for say 2 files and let the deletion happen for other remaining files.

|||Possibly - I'm not sure. I haven't seen a way to do it...

file Server and Ful text indexing

Dear All,
Is it possible for SQL Server to search on documents which are not inserted
into the database?
for example does SQL Server have the facility to scan the documents, keeping
the documents in the fileserver itself and doing full-text indexing on them
taking only the token words from it. (These token words can be inserted into
database as indexes).
A similar facility is provided bu ORACLE-Text.
We are new to this area. So any hints on this would be advantageous for us.
Very thanks in anticipation.
Also please give us the utilities/tools which are readily available which
can be integrated with SQL Server / .Net Applications for database and
Documents Search.
Regards
SathianSathian,
Yes, but not using SQL Server's "full text search" components, instead you
would use the Indexing Service and create a Linked Server to IS via the
MSIDXS OLE-DB provider. See SQL Server 2000 BOL title's "OLE DB Provider for
Microsoft Indexing Service" and sp_addlinkedserver from more info on this.
Note, while this is functional, it does not perform very well.
I believe that the ORACLE Text (an expensive add-on) feature you're
refereing to is called "Oracle Ultra Search". Correct? This is another "for
fee" spider based service of ORACLE Text, that has no direct feature
comparison in SQL Server 2000 or 2005 Full Text Search, I'm to say...
If you're interested in more details, feel free to email me directly.
Thanks,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Sathian T" <sathian.t@.in.Bosch.com> wrote in message
news:d188gf$itc$1@.ns2.fe.internet.bosch.com...
> Dear All,
> Is it possible for SQL Server to search on documents which are not
inserted
> into the database?
> for example does SQL Server have the facility to scan the documents,
keeping
> the documents in the fileserver itself and doing full-text indexing on
them
> taking only the token words from it. (These token words can be inserted
into
> database as indexes).
> A similar facility is provided bu ORACLE-Text.
> We are new to this area. So any hints on this would be advantageous for
us.
> Very thanks in anticipation.
> Also please give us the utilities/tools which are readily available which
> can be integrated with SQL Server / .Net Applications for database and
> Documents Search.
> Regards
> Sathian
>

file import to SQL Server 2000

Hi all,

I have a file with an extension of .sdf. I "believe" it is a text file
of some sort but I am uncertain. The source agency hasn't returned any
of my calls so I'm wondering if anyone is familiar with this extension?
I'd like to import the file into my database - when I use DTS and chose
a text format, regardless of what delimiter I choose, the format is
still really ugly. when I pull it up in a huge text editor, it is hard
for me to tell what it is there.

I saw in one of my searches that it could be a comma delimited (it's
not) .. could be a unisys file? I know it's not much information to go
on - but where should I start in trying to get this into my database
without knowing the format? Any suggestions would be greatly
appreciated.

Thanks!
Bethany

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!A google search turned up

SDF = Windows SQL CE-version internal databases
SDF = MDL Isis SDF chemical modeller input file
SDF = Mime: application/e-score
SDF = Mime: chemical/x-mdl-sdf
SDF = Source Definition File (Sourcer)
SDF = System Data Format file (fixed lenght ascii text)

> know it's not much information to go on -
> but where should I start in trying to get this into my database
> without knowing the format?

All you can do is make assumptions and try to identify the file format via
trial-and-error. You might get help with identifying/eliminating SQL CE
from the microsoft.public.sqlserver.ce.

Once you've positively identified the file format, you can take steps to
either import directly or at least transform data into an intermediate
format suitable for import.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Bethany Holliday" <bhollida@.iupui.edu> wrote in message
news:418a7210$0$14507$c397aba@.news.newsgroups.ws.. .
> Hi all,
> I have a file with an extension of .sdf. I "believe" it is a text file
> of some sort but I am uncertain. The source agency hasn't returned any
> of my calls so I'm wondering if anyone is familiar with this extension?
> I'd like to import the file into my database - when I use DTS and chose
> a text format, regardless of what delimiter I choose, the format is
> still really ugly. when I pull it up in a huge text editor, it is hard
> for me to tell what it is there.
> I saw in one of my searches that it could be a comma delimited (it's
> not) .. could be a unisys file? I know it's not much information to go
> on - but where should I start in trying to get this into my database
> without knowing the format? Any suggestions would be greatly
> appreciated.
> Thanks!
> Bethany
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!