Thanks for your reply, Eugene. Forgot the brackets. =(

Sorry guys. I figured it out.

There is erroneous data value in the table. =(

Msg 241, Level 16, State 1, Line 1

Syntax error converting datetime from character string.

It didn't make sense as if I do:

SELECT convert(datetime,'2004-08-24',120)

2004-08-24 00:00:00.000

It works!

I was able to change the data to

08-24-2004

08-25-2004

08-26-2004

select CONVERT(datetime, F3, 103) from _CalendarDate

Msg 242, Level 16, State 3, Line 1

The conversion of a char data type to a datetime data...

CREATE TABLE [dbo].[_CalendarDate](

[F1] [varchar](20) NULL

) ON [PRIMARY]

select * from dbo._CalendarDate

8242004

8252004

8262004

select CONVERT(datetime, F1, 103) from _CalendarDate

Syntax error converting datetime from character string.

I want to convert it to datetime, any idea?

I end up created a function instead.

I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?

It's to do with the code. =)

No, thru from another data flow destination

There is no trigger.

I figure out.

Thanks for replying.

The Microsoft Search is run by LocalSystem. Do I need to change it?

Ramesh (10/17/2007)

---

Noel,

Full text search is a service named as Microsoft Search OR MSFTESQL...

You can go to services console...

I'm using SQL Server 2000,

Is there Surface Area Configuration tool in SQL2000?

Pam Brisjar (10/16/2007)

---

It's a Windows service account:

SQL Server FullText Search (MSSQLSERVER)

Right click, go to properties and check the Log...

Under Services,

I don't see SQL Server FullText Search, I only see MSSQLSERVER and Microsoft Search

Pam Brisjar (10/16/2007)

---

It's a Windows service account:

SQL Server FullText Search (MSSQLSERVER)

Right click, go to properties and...

Thanks for your reply, Pam.

Can you guide me where can I find the full text agent id?

Thanks again

Pam Brisjar (10/16/2007)

---

1) Nope. It's the new security settings.

2) Again, check...

Don't worry!

I figured it out!

Thanks anyways!