Bonjour,

Mes packages SSIS constituent un ensemble de 5 STEPS qui doivent être lancés automatiquement dans un job de l'Agent SQL Server 2005.

1 LOAD1 DB
2 Sessions DB
3 FAITS LOAD1 DB
4 FAITS BROKER DB
5 REF DB

Le premier STEP se déroule sans accroc mais les choses se compliquent au deuxième.

On a alors essayé de shunter ce STEP pour lancer le 3 après le 1,mais ça ne s'arrange pas, voyez plutôt :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
03/25/2010 11:10:00,MAG_LOG_EXPLOIT,Error,0,A92SV09101SQL,MAG_LOG_EXPLOIT,(Job outcome),,The job failed.  The Job was invoked by Schedule 5 (TEST).  The last step to run was step 3 (FAIT LOAD1).,00:05:52,0,0,,,,0
03/25/2010 11:15:20,MAG_LOG_EXPLOIT,Error,3,A92SV09101SQL,MAG_LOG_EXPLOIT,FAIT LOAD1,,Executed as user: A92SV09101SQL\SYSTEM. ...00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:15:20  Error: 2010-03-25 11:15:51.96     Code: 0xC0202009     Source: DFT Charger FAITS à partir de LOAD1 OLE DB Source LOAD1 [38108]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.  End Error  Error: 2010-03-25 11:15:51.96     Code: 0xC02020E8     Source: DFT Charger FAITS à partir de LOAD1 OLE DB Source LOAD1 [38108]     Description: Opening a rowset for "[dbo].[LOAD1]" failed. Check that the object exists in the database.  End Error  Error: 2010-03-25 11:15:51.96     Code: 0xC004706B     Source: DFT Charger FAITS à partir de LOAD1 DTS.Pipeline     Description: "component "OLE DB Source LOAD1" (38108)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2010-03-25 11:15:51.96     Code: 0xC004700C     Source: DFT Charger FAITS à ...  The package execution fa...  The step failed.,00:00:32,0,0,,,,0
03/25/2010 11:14:48,MAG_LOG_EXPLOIT,Error,2,A92SV09101SQL,MAG_LOG_EXPLOIT,SESSION,,Executed as user: A92SV09101SQL\SYSTEM. ...00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:14:48  Error: 2010-03-25 11:15:20.18     Code: 0xC0202009     Source: DFT LIGNES ALL OLE DB  Nbsessions ALL [27780]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.  End Error  Error: 2010-03-25 11:15:20.18     Code: 0xC02020E8     Source: DFT LIGNES ALL OLE DB  Nbsessions ALL [27780]     Description: Opening a rowset for "[dbo].[NBSESSIONS]" failed. Check that the object exists in the database.  End Error  Error: 2010-03-25 11:15:20.18     Code: 0xC004706B     Source: DFT LIGNES ALL DTS.Pipeline     Description: "component "OLE DB  Nbsessions ALL" (27780)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2010-03-25 11:15:20.18     Code: 0xC004700C     Source: DFT LIGNES ALL DTS.Pipeline     Description: One or more component fa...  The package execution fa...  The step failed.,00:00:32,0,0,,,,0
03/25/2010 11:10:00,MAG_LOG_EXPLOIT,Unknown,1,A92SV09101SQL,MAG_LOG_EXPLOIT,LOAD1,,Executed as user: A92SV09101SQL\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:10:00  DTExec: The package execution returned DTSER_SUCCESS (0).  Started:  11:10:00  Finished: 11:14:48  Elapsed:  287.469 seconds.  The package executed successfully.  The step succeeded.,00:04:48,0,0,,,,0
03/25/2010 10:55:01,MAG_LOG_EXPLOIT,Error,0,A92SV09101SQL,MAG_LOG_EXPLOIT,(Job outcome),,The job failed.  The Job was invoked by Schedule 5 (TEST).  The last step to run was step 2 (SESSION).,00:07:10,0,0,,,,0
03/25/2010 11:01:39,MAG_LOG_EXPLOIT,Error,2,A92SV09101SQL,MAG_LOG_EXPLOIT,SESSION,,Executed as user: A92SV09101SQL\SYSTEM. ...00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  11:01:39  Error: 2010-03-25 11:02:11.16     Code: 0xC0202009     Source: DFT LIGNES ALL OLE DB  Nbsessions ALL [27780]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.  End Error  Error: 2010-03-25 11:02:11.16     Code: 0xC02020E8     Source: DFT LIGNES ALL OLE DB  Nbsessions ALL [27780]     Description: Opening a rowset for "[dbo].[NBSESSIONS]" failed. Check that the object exists in the database.  End Error  Error: 2010-03-25 11:02:11.16     Code: 0xC004706B     Source: DFT LIGNES ALL DTS.Pipeline     Description: "component "OLE DB  Nbsessions ALL" (27780)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2010-03-25 11:02:11.16     Code: 0xC004700C     Source: DFT LIGNES ALL DTS.Pipeline     Description: One or more component fa...  The package execution fa...  The step failed.,00:00:32,0,0,,,,0
03/25/2010 10:55:01,MAG_LOG_EXPLOIT,Unknown,1,A92SV09101SQL,MAG_LOG_EXPLOIT,LOAD1,,Executed as user: A92SV09101SQL\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:55:01  DTExec: The package execution returned DTSER_SUCCESS (0).  Started:  10:55:01  Finished: 11:01:39  Elapsed:  398.156 seconds.  The package executed successfully.  The step succeeded.,00:06:38,0,0,,,,0
03/24/2010 20:00:00,MAG_LOG_EXPLOIT,Error,0,A92SV09101SQL,MAG_LOG_EXPLOIT,(Job outcome),,The job failed.  The Job was invoked by Schedule 5 (TEST).  The last step to run was step 2 (SESSION).,00:07:27,0,0,,,,0
03/24/2010 20:06:55,MAG_LOG_EXPLOIT,Error,2,A92SV09101SQL,MAG_LOG_EXPLOIT,SESSION,,Executed as user: A92SV09101SQL\SYSTEM. ...00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  20:06:55  Error: 2010-03-24 20:07:27.58     Code: 0xC0202009     Source: DFT LIGNES ALL OLE DB  Nbsessions ALL [27780]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37.  End Error  Error: 2010-03-24 20:07:27.60     Code: 0xC02020E8     Source: DFT LIGNES ALL OLE DB  Nbsessions ALL [27780]     Description: Opening a rowset for "[dbo].[NBSESSIONS]" failed. Check that the object exists in the database.  End Error  Error: 2010-03-24 20:07:27.60     Code: 0xC004706B     Source: DFT LIGNES ALL DTS.Pipeline     Description: "component "OLE DB  Nbsessions ALL" (27780)" failed validation and returned validation status "VS_ISBROKEN".  End Error  Error: 2010-03-24 20:07:27.61     Code: 0xC004700C     Source: DFT LIGNES ALL DTS.Pipeline     Description: One or more component fa...  The package execution fa...  The step failed.,00:00:32,0,0,,,,0
03/24/2010 20:00:00,MAG_LOG_EXPLOIT,Unknown,1,A92SV09101SQL,MAG_LOG_EXPLOIT,LOAD1,,Executed as user: A92SV09101SQL\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  20:00:01  Error: 2010-03-24 20:00:17.18     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "PassWord" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  DTExec: The package execution returned DTSER_SUCCESS (0).  Started:  20:00:01  Finished: 20:06:55  Elapsed:  414.125 seconds.  The package executed successfully.  The step succeeded.,00:06:55,0,0,,,,0


Un grand merci au Champollion moderne qui saura décrypter ces hiéroglyphes