prvmine (9/9/2011)

---

Yes you can transfer data from one server to another with an SSIS Package.

Would suggest creating the package with SQL Server 2008 BIDS and deploying to the SQL 2008...

Hi, I am trying to create a linked server from SQL server 2005 to SQL Server 2008.

I created the DSN.

I created a user, same login id and password for both...

Hi Kevin, Yes, because of time, I think I will do the linked server way first. I have used SSIS packages before but it were running between 2 sql server...

prvmine (9/9/2011)

---

Yes you can transfer data from one server to another with an SSIS Package.

Would suggest creating the package with SQL Server 2008 BIDS and deploying to the SQL 2008...

Hmm, I think I need to use the AND condition with Contains, but AND is not giving expected results whereas OR condition works fine.

~ Janki

Let's take a look at what you're doing. Let's say you've got <a>cat in the hat</a> and category in a document. You're going to have to look for...

Hi Kazim

If your requirement is what you have told in your post :: Posted 8/6/2011 10:16:45 PM

then yes you can use Full Text Search.

---------------------600 page PDF post------------------------

When you say, the...

Please ignore the BOLD ...just read the sentence!! It was accidentally changed to that BIG BOLD TEXT !!!

srinivas-406082 (11/30/2010)

---

Hi,I am implementing full text search in our dB. I'm able to search .doc, .xls files but not .docx and .xlsx files. I've the latest filters pack (office 2010)...

['linkedservername' should be the actual name of your Linked Server - is it? ]

Yes, in the actual query, I have just replaced the actual linked-server-name with linkedservername and the actual...

Hi Paul,

I tried this

declare @InputPara varchar(100)

set @InputPara='Hello'

declare @OutputPara bigint

EXECUTE ( 'BEGIN ? := packagename.functionname(?,?); END;', @InputPara, @OutputPara OUTPUT )at linkedservername;

Its giving me this error

Msg 7215, Level 17, State 1,...

Finally............................................... It started working.

I did couple of things like setting the System-->Path variable,

Rebuilding the catalog, Indexing options ....

uninstalling, re-installing the PDFFilter.dll

and rebooted the server several times!

Not sure what triggered...

Installed PDFFilter for 64 bit again and this time after rebooting the server the path showed correctly in sys.fulltext_document_types, system view.

(C:/windows/system32/bin/pdffilter.dll)

But the search returns nothing.

Please share your solutions if...

I am also able to call it from .NET application using System.Data.OracleClient and the connection string.

But due to some limitations I have to call it from the SQL Server only.

I...

When I...