• Check the following:

    1. Make sure the account that the sql server agent is running under has sufficient priveleges to perform the dts task.

    2. Make sure any paths to files are through a mapped drive rather than the full unc path.

    3. Run dcomcnfg.exe and add the SQL Service account to Default Access Permissions under Default Security tab.


    ------------------------------
    The Users are always right - when I'm not wrong!