Answer from Elliot W (use of 32bit DTExec) was spot on.

One thing to note. If you password protect your ssis packages, cmdexec does not allow the use of /FILE and...

Phil,

Sorry to clarify, by manually i mean, creating a job under sql server agent and executing through right click, start job at step etc..

I am logged into sql server as...

Dan,

Yes, the Access file resides locally and the server has correct permissions.

yes dave almost identical to something i had just before lunch!

SELECT

rowid

FROM

customer as main

INNER JOIN

customer as sub

ON...

very nice, although id suggest one thing

link to a dw to hold all of the previously generated passwords, and then check if the generated password has been generated before:

if...