that seems to relate to partitioned indexes

Ive tested it and it works ok without Access actually being installed on the server

so how would I add it to the GAC ? The deployment server has the .net framework 2.0.50727 installed, but vsjlib.dll is not present

ok, figure this one out if you can. In desperation I completely removed the package from sql server and reinstalled it, now it works ! wtf ?

yeah Ive set delayvalidation to true

I changed the account that the sql agent runs under to my local windows account (this does have access to the remote machine) and it works.

But I now have a...

Ok, I changed the account to my windows login account and entered my password, this seemed to work. So now the SQL server agent is running under my...

Ive accessed the SQL server 2005 configuration tool and tried to change the account that the sql server agent runs under. Ive changed it to my own account, but...

Its running under local system. How can i check if this account has access to the remote server ?

\Package.Connections[Property].

refers to the actual property, not the database name (confusing I know, but I inherited this database, and thats what its called)

Property is the name of the database

anyone ?

the sql server agent is running under the local system account

Ive rebooteed the machine, but it makes no difference, the job is still failing.

This makes no sense, it ran ok first time, all I did was change the server name...

its only the source data in the access files that isnt password protected, the sql server stuff uses integrated security so passwords shouldnt be an issue there. I havent...