problem in scheduling a SSIS package -
07-20-2006
, 03:55 AM
Hi,
I have an import package to copy an Access table to Sql Server 2005.
Running with the executing package utility it works properly, but on Sql
Agent it doesn't.
The .mdb file is stored in a different server in the same workgroup (no
active directory).
Following the guide I've created the credentials and the SSIS proxy:
The identity credential is SRVSQL\Administrator. The password is the same as
in the SRVMDB\Administrator user in the server that stores the .mdb file.
The job step runs as the proxy account.
What did I miss?
Thanks |