Is it possible to perform terms lookup on unstructured files ?

Hi,
I need to categorize a lot of html or text files according to a list of terms and I wonder if terms lookup is adequate for this. The problem is that terms lookup can only take an Oledb source as input. My files can be up to 80 Kb big and aren't columns structured.

Should I import my files in a table ? But if so, how can I import a column with more than 8000 characters ?

Thank you in advance.

I think you may have this the wrong way around. The list of terms must be stored in an OLE-DB sourced table, but the input is the data you want to examine. This can come from any upstream component. You will still need to get your data into the pipeline, but that is perhaps not quite as hard as OLE-DB. Maybe the Import Column Transform could help?

You mention a 8000 character limit, which is the limit for non-unicode strings in the varchar (T-SQL) or DT_STR (SSIS) data types. Whilst the Term transformations only support unicode data types, with their 4000 character limit, they do support the DT_NTEXT type, equivalent to the T-SQL ntext type, which allows up to 2GB of data.

|||Thank you very much for your quick reply. My mistake, you're right, I'm a new user of SSIS and I misunderstood the explanations on the lookup. I'm digging into this. Thanks again for your help.

Is it possible to perform Sql 7 Enterprise upgrade to Sql 200o Standard Editions

Hi all,

I was curious if there any issues that I need to be aware off in attempting to upgrade an existing client database (Sql Server 7 Enterprise Edition) to Sql 2000 Standard edition. During upgrades are we forced to stay with the same editions or can the upgrade to lower level editions.

Thanks
ZeidNot possible, you need to uninstall and re-install SE.
EE is far superior than SE by any means.

is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanks
Hi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks
|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:

> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks

is it a good practice to do integrity check before perform backup?

On maintenance plan, there is a check box on integrity tab page, is it a good
way to do that first? if there is error found, will the backup stop? thanksHi
It depends on what error it will find. Actually, you can checkbox but make
sure that you uncheck Attempt to repair... option.
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:06E26A1F-4F08-4D81-9502-07E9DB0F5041@.microsoft.com...
> On maintenance plan, there is a check box on integrity tab page, is it a
> good
> way to do that first? if there is error found, will the backup stop?
> thanks|||My approach is that if you have plenty of maintenance window for doing the
integraity checks (i.e. DBCC checks), do them by all means. And if you are
running into integrity issues, you may want to perform the DBCC checks more
regularly. It becomes a more difficult question when you are dealing with a
large amount of data and when you are struggling to contain your maintenance
jobs inside a limited maintenance window. In that case, you may have to forgo
the DBCC checks or do them very selectively.
Linchi
"tulip" wrote:
> On maintenance plan, there is a check box on integrity tab page, is it a good
> way to do that first? if there is error found, will the backup stop? thanks