You mean create adummy table with same schema and add 4 flies and 1 new file to that table and then truncate original table.

but i do no have enough space...

I find that role in msdb database but how can i add a user to that role.

But where do i find these roles, i dont see them in server roles of the instance.

SQLAgentUserRole and SQLAgentReaderRole

I understand only server admin can run the jobs but am looking for a way where a user can be given access only to a job which he needs to...

this is the only process accessing the spreadsheet.

there is no option called disable step in 2005 we can just delete the step.

In sql 2000 was very gud in this regard for running each single step seperately,...

That didnt work for me still i get the error

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" reported an error. The provider...

its resolved, i can look into the package now but looks very much diffrent when comapred to DTS pkg.

How could i make it as sql job and also need to...

is it OK to change the file MsDtsSrvr.ini.xml? am worried if it will mess up something else on my server.

WHat should i change there

yes, OPENROWSET is enabled.

I tried that in query window and get this error

OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find...

yes, when i type in link in the run cmd my excel sheet shows up..so?

i am runnig with windows user.

I am trying to connect to my database instance through windows authentication. also I configured windows firewall to allow sql server

can some one help me in this.. its really urgent.