1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
| SSIS package "C:\Users\jaafar\documents\visual studio 2010\Projects\Test1ETL\Test1ETL\importation client.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC00470BA at Data Flow Task, Slowly Changing Dimension [207]: The "Slowly Changing Dimension.Inputs[Slowly Changing Dimension Input].Columns[Copy of Address]" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
Error: 0xC00470BA at Data Flow Task, Slowly Changing Dimension [207]: The "Slowly Changing Dimension.Inputs[Slowly Changing Dimension Input].Columns[Copy of LastName]" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
Error: 0xC00470BA at Data Flow Task, Slowly Changing Dimension [207]: The "Slowly Changing Dimension.Inputs[Slowly Changing Dimension Input].Columns[Copy of Name]" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC00470BA at Data Flow Task, Slowly Changing Dimension [207]: The "Slowly Changing Dimension.Inputs[Slowly Changing Dimension Input].Columns[Copy of Address]" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
Error: 0xC00470BA at Data Flow Task, Slowly Changing Dimension [207]: The "Slowly Changing Dimension.Inputs[Slowly Changing Dimension Input].Columns[Copy of LastName]" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
Error: 0xC00470BA at Data Flow Task, Slowly Changing Dimension [207]: The "Slowly Changing Dimension.Inputs[Slowly Changing Dimension Input].Columns[Copy of Name]" has a long object data type of DT_TEXT, DT_NTEXT, or DT_IMAGE, which is not supported.
Warning: 0x80049304 at Data Flow Task, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Email" (14) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "PhoneNumber" (16) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "IdentificationCard" (17) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "IdentificationCardNumber" (18) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "DeliveryDate" (19) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Place" (20) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Civility" (21) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "ZipCode" (23) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "BankName" (24) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "AgencyName" (25) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Town" (26) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "HaveAccount" (27) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "BankAccount" (28) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Password" (29) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "PhotoName" (30) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Blocked" (31) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "FirstConnexion" (32) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "CountryID" (33) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "ProfessionID" (34) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "ActivityFieldID" (35) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "NumberOfNotification" (36) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "IsMan" (37) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "IsAdmin" (38) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Camera" (39) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "UserProfileId" (40) on output "ADO NET Source Output" (10) and component "Base de production" (2) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Copy of UserID" (112) on output "Data Conversion Output" (111) and component "Data Conversion" (104) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Warning: 0x80047076 at Data Flow Task, SSIS.Pipeline: The output column "Copy of Birthday" (124) on output "Data Conversion Output" (111) and component "Data Conversion" (104) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
Error: 0xC0047022 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Slowly Changing Dimension" (207) failed with error code 0x80070057 while processing input "Slowly Changing Dimension Input" (218). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "Insert Destination" wrote 0 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Data Flow Task
Warning: 0x80019002 at importation client: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (4) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "C:\Users\jaafar\documents\visual studio 2010\Projects\Test1ETL\Test1ETL\importation client.dtsx" finished: Failure.
Le programme '[872] DtsDebugHost.exe: DTS' s'est arrêté avec le code 0 (0x0). |
Exécution de slowly changing dimension
Répondre avec citation
Envoyé par rw72000
Partager