Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DTS Package
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Divers
Thread ID:
00667970
Message ID:
00668149
Vues:
29
>okay I got as far as
>
>use msdb
>exec sp_start_job @jobname = 'Update_WebNTI'
>
>and the job starts but fails... the package runs fine...

Use of sp_start_job will run on the server, so no need to have DTSRUN local. The problem with the package may now be on permissions, make sure that the account for the job owner has sufficient permissions to access the files/folders used by the package, or if it requires a DSN it needs to be defined on the server.

Go to the job history details and you will know more about the problem as well as the account the job is running under.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform