Bonjour,
Je tente de lancer un package SSIS via un agent SQL. Le package SSIS est chargé d'implémenter un fichier Excel sur la base d'une requête SQL. Il fonctionne sans problème lorsque je le lance du SSIS (Visual studio 2010). Voici l'anomalie:
Je précise que le package SSIS et l'agent SQL ont été crées avec le même utilisateur. Quelqu'un a une idée? Merci
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17 Date 09/07/2015 16:10:16 Log Job History (New_transfert_TDHQ) Step ID 1 Server GETEB-HISTORIAN Job Name New_transfert_TDHQ Step Name Transfert données SSIS Duration 00:00:00 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 16:10:16 Error: 2015-07-09 16:10:16.25 Code: 0xC0011007 Source: {F0C416D3-62A7-44C1-8B9E-D2C50ADC1550} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2015-07-09 16:10:16.25 Code: 0xC0011002 Source: {F0C416D3-62A7-44C1-8B9E-D2C50ADC1550} Description: Failed to open package file "C:\Users\GMC\Documents\Gilles\Transfert puissances TDHQ MSO\Transfert puissances TDHQ MSO\Package.dtsx" due to error 0x80070005 "Accès refusé.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. End Error Could not load package "C:\Users\GMC\Documents\Gilles\Transfert puissances TDHQ MSO\Transfert puissances TDHQ MSO\Package.dtsx" because of error 0xC0011002. Description: Failed to open package file "C:\Users\GMC\Documents\Gilles\Transfert puissances TDHQ MSO\Transfert puissances TDHQ MSO\Package.dtsx" due to error 0x80070005 "Accès refusé.". This occurs when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of specifying an incorrect file name when calling LoadPackage or the specified XML file has an incorrect format. Source: {F0C416D3-62A7-44C1-8B9E-D2C50ADC1550} Started: 16:10:16 Finished: 16:10:16 Elapsed: 0.016 seconds. The package could not be found. The step failed.
Partager