lol no problem.

I have changed the SQL 2005 DB compatibility level to "90".

Also when I run you SQl:

select * from tbldeals

where CONVERT(VARCHAR(10),trade_date,111) = '2009/03/06'

It works fine.... whats the...

Thanks for the info.

When I run sp_dbcmptlevel 'Dealbookv2' against both DB's (2000 & 2005)

I get The current compatibility level is 80.

Is this correct?

There is 4 columns altogether.

Problem is the people we get the file from will charge us to make this change and thats somthing "we" (The man above) does not want.....

For...

Thanks for the info.

I really want to avoid touching the file! (Long story)

The really problem is that, there are 4 columns and no delimiters and I need only to import...

thanks Ramesh

Yes I suppose it is....

And how would i do it...

According to your description, you know the flat file has an error but you dont want the import/SSIS to fail.

Therefore you can try,

1. Opening the Flat File Sourse Editor

2....

ok i get the hint!!!!!!

Thanks guys.

Question, what do you mean by:

Compat mode 80/90?

How would I:

update all statistics on 2005

run DBCC updateusage

run DBCC CheckDB with the DATA_PURITY option.

Thank you!!!

I did'nt see the Operators Node!!]:w00t:

If i go to the Job Properties, under Notifications I have removed the operator.

Basically unchecked the Email box.

But if I get to th Alters tab and select Add, I can...

As there is no option to right click and delete!!

No this does not work!

Not sure if this is going to help but can you change it to:

'Rely on server storage and roles for access control'

P.s. Not sure if you can change it, you...

Ok found this article, fixed the issue:

http://www.sqlservercentral.com/articles/Administering/usingdifferenttechniquesforsqlserverautomation/1429/