Showing posts with label loaded. Show all posts
Showing posts with label loaded. Show all posts

Thursday, March 29, 2012

FTP Task Completes but No File

I have an FTP task that once the file is loaded a script task is activated and then a data flow process starts. I can connect to the FTP server with the Test connection and I can see the file in the remote directory "/HRData.txt" however even with the Delay validation set to true it does not download the file.the only thing i can think of is to try re-creating the task.|||I have already tried this with no affect. I guess I am going to try to write a FTP download into my script that I am executing.

Sunday, February 26, 2012

Free Text Search

We have two SQL Server 2000 servers with SP4 loaded. We have copied a
database from one to the other. The free text search runs on the original
server and produces results but on the new server it runs but produces a nil
return.
Can anyone offer any help?
Confused but battling on
"Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> database from one to the other. The free text search runs on the original
> server and produces results but on the new server it runs but produces a
> nil
> return.
Free text?
I assume you mean FULL TEXT?
Did you copy the Full-text indices to the same place?
Did you enable full-text on the new database?
How was the data moved?

> Can anyone offer any help?
> --
> Confused but battling on
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Sorry I did mean full text search. We have tried to re create the indices
and the search but it still returns a nil result. The full text search
service is running.
How do you enable full text search on a database?
The database was moved by backing up to a device, then copying the device to
the new location and restoring it (changing the file locations etc).
Eeverything else in the database works fine; it is just this full text search
Confused but battling on
"Greg D. Moore (Strider)" wrote:

> "Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
> news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> Sorry I did mean Full Text Search.
The full text searches had been copied to the same place and I'm not sure
what you mean about enabling full test searches on the database.
The full text search service is running
> Free text?
> I assume you mean FULL TEXT?
> Did you copy the Full-text indices to the same place?
> Did you enable full-text on the new database?
> How was the data moved?
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>
>

Free Text Search

We have two SQL Server 2000 servers with SP4 loaded. We have copied a
database from one to the other. The free text search runs on the original
server and produces results but on the new server it runs but produces a nil
return.
Can anyone offer any help?
--
Confused but battling on"Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> database from one to the other. The free text search runs on the original
> server and produces results but on the new server it runs but produces a
> nil
> return.
Free text?
I assume you mean FULL TEXT?
Did you copy the Full-text indices to the same place?
Did you enable full-text on the new database?
How was the data moved?
> Can anyone offer any help?
> --
> Confused but battling on
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Sorry I did mean full text search. We have tried to re create the indices
and the search but it still returns a nil result. The full text search
service is running.
How do you enable full text search on a database?
The database was moved by backing up to a device, then copying the device to
the new location and restoring it (changing the file locations etc).
Eeverything else in the database works fine; it is just this full text search
--
Confused but battling on
"Greg D. Moore (Strider)" wrote:
> "Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
> news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> > We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> > database from one to the other. The free text search runs on the original
> > server and produces results but on the new server it runs but produces a
> > nil
> > return.
> Sorry I did mean Full Text Search.
The full text searches had been copied to the same place and I'm not sure
what you mean about enabling full test searches on the database.
The full text search service is running
> Free text?
> I assume you mean FULL TEXT?
> Did you copy the Full-text indices to the same place?
> Did you enable full-text on the new database?
> How was the data moved?
>
> >
> > Can anyone offer any help?
> >
> > --
> > Confused but battling on
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>
>

Free Text Search

We have two SQL Server 2000 servers with SP4 loaded. We have copied a
database from one to the other. The free text search runs on the original
server and produces results but on the new server it runs but produces a nil
return.
Can anyone offer any help?
Confused but battling on"Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> database from one to the other. The free text search runs on the original
> server and produces results but on the new server it runs but produces a
> nil
> return.
Free text?
I assume you mean FULL TEXT?
Did you copy the Full-text indices to the same place?
Did you enable full-text on the new database?
How was the data moved?

> Can anyone offer any help?
> --
> Confused but battling on
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Sorry I did mean full text search. We have tried to re create the indices
and the search but it still returns a nil result. The full text search
service is running.
How do you enable full text search on a database?
The database was moved by backing up to a device, then copying the device to
the new location and restoring it (changing the file locations etc).
Eeverything else in the database works fine; it is just this full text searc
h
--
Confused but battling on
"Greg D. Moore (Strider)" wrote:

> "Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
> news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> Sorry I did mean Full Text Search.
The full text searches had been copied to the same place and I'm not sure
what you mean about enabling full test searches on the database.
The full text search service is running
> Free text?
> I assume you mean FULL TEXT?
> Did you copy the Full-text indices to the same place?
> Did you enable full-text on the new database?
> How was the data moved?
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com [url]http://www.greenms.com/sqlserver.html[/ur
l]
>
>