Showing posts with label xls. Show all posts
Showing posts with label xls. Show all posts

Wednesday, March 28, 2012

How to assign values to a variable from a xls sheet?

I've got this query inside a Sql Task against a Excel connection and I'd like to insert that value into a user variable called "Proyecto". How do I such thing?

select Proyecto from [Carga$]

TIA,

I'm so sorry it's solved!!

I promise you that from now on I'll try not be so impatient..

Friday, March 9, 2012

How to add document type in full - text search (ifiter)

Dear all,
I use full-text search in SQL2005, but i discover it only support some
document types (.doc \ .xls .. , select * from sys.fulltext_document_types
),i want to it also support PDF type, well then, how i can do it?
by the way. I download a ifilter from adobe website and installed. but
also can't support the pdf type.
thanks & regards
jp ye
"jp" <yjp_it@.yahoo.com.cn> wrote in message
news:3E9576E9-041E-496E-91C4-4AD1B39360CB@.microsoft.com...
> Dear all,
> I use full-text search in SQL2005, but i discover it only support some
> document types (.doc \ .xls .. , select * from sys.fulltext_document_types
> ),i want to it also support PDF type, well then, how i can do it?
> by the way. I download a ifilter from adobe website and installed. but
> also can't support the pdf type.
You might get a faster answer if you re-post this to
microsoft.public.sqlserver.fulltext. They deal specifically with FTS
issues.

How to add document type in full - text search (ifiter)

Dear all,
I use full-text search in SQL2005, but i discover it only support some
document types (.doc \ .xls .. , select * from sys.fulltext_document_types
),i want to it also support PDF type, well then, how i can do it?
by the way. I download a ifilter from adobe website and installed. but
also can't support the pdf type.
thanks & regards
jp ye"jp" <yjp_it@.yahoo.com.cn> wrote in message
news:3E9576E9-041E-496E-91C4-4AD1B39360CB@.microsoft.com...
> Dear all,
> I use full-text search in SQL2005, but i discover it only support some
> document types (.doc \ .xls .. , select * from sys.fulltext_document_types
> ),i want to it also support PDF type, well then, how i can do it?
> by the way. I download a ifilter from adobe website and installed. but
> also can't support the pdf type.
You might get a faster answer if you re-post this to
microsoft.public.sqlserver.fulltext. They deal specifically with FTS
issues.

How to add document type in full - text search (ifiter)

Dear all,
I use full-text search in SQL2005, but i discover it only support some
document types (.doc \ .xls .. , select * from sys.fulltext_document_types
),i want to it also support PDF type, well then, how i can do it?
by the way. I download a ifilter from adobe website and installed. but
also can't support the pdf type.
--
thanks & regards
jp ye"jp" <yjp_it@.yahoo.com.cn> wrote in message
news:3E9576E9-041E-496E-91C4-4AD1B39360CB@.microsoft.com...
> Dear all,
> I use full-text search in SQL2005, but i discover it only support some
> document types (.doc \ .xls .. , select * from sys.fulltext_document_types
> ),i want to it also support PDF type, well then, how i can do it?
> by the way. I download a ifilter from adobe website and installed. but
> also can't support the pdf type.
You might get a faster answer if you re-post this to
microsoft.public.sqlserver.fulltext. They deal specifically with FTS
issues.