I have stop all sql server services, manually added sysadmin sql server role to the windows account used by the agent and restarted all sql services and it is now...

It seems to be a known issue..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1565378&SiteID=1&pageid=0

It must something to do with permissions and the sql agent (although the account has local admin and is sa on the...

The CSV files are on the server and the sql agent is using a windows account

yes it works if im not using the agent.

I also tried using xp_cmdshell with T-sql step but no luck

Im getting the csv files but nothing gets inserted to the db..am...

Thank you for your reply cmille19, the job works fine for generating the csvs but after running run-smo step im getting this:

The step did not generate any output. Process...

I am getting the same problem as Jonathan, is there a workaround for this when using the agent to run the job?

You probably need to follow the steps mentioned above in a sequential order. It took me a while to make it work and I still dont have a clear understanding...

If by no means SQL 2000 SP4 and SP3 are not fixing this error then you need to do a clean install:

- install SQL 2000 client

- install SQL 2005 server

-...

If by no means SQL 2000 SP4 and SP3 are not fixing this error then you need to do a clean install:

- install SQL 2000 client

- install SQL 2005 server

-...

Was having the same problem just now...Just uninstall native client through control panel add/remove programs - delete all instances - then uninstall 2005 again and it should work.

Thanks

Thibaut