Thats already enabled...doesnt help...

Thanks!!

I did look online, some suggest making changes to surface area configuration like enable OLE Automation...is that required?...tried that as well but no luck

I still have problems running the query....can...

Thanks Samuel,

I am really interested in uploading the fields that I want from csv file into the table rathar than doing a mass upload. Is that what the SSIS package...

It still does not work, giving the same error that I posted before.

Also do I have to use double quotes? it is giving me syntax error if i do that.

Thanks...

also i am using 32bit standard edition sql server 2005

Thanks for the reply....i tried the code but i get this error...

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Text Driver] System resource exceeded.".

Msg 7303, Level 16,...

I am facing the same problem. I have 32 bit standard edition of sql server 2005, trying to install on 64 bit windows vista.

I disabled the User Access Control.

Also...