|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DTEXEC command line errorI get the following error when i run the SSIS package from the DTEXEC command line utility. Any specific reason for this error? Thanks in advance Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Progress: 2006-06-07 20:26:10.79 Source: Data Flow Task Validating: 100% complete End Progress Warning: 2006-06-07 20:26:10.93 Code: 0x80047076 Source: Data Flow Task DTS.Pipeline Description: The output column "FIELD_27" (3423) on output "Flat File Source Output" (3329) and component "Flat File Source 1" (3328) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. End Warning Warning: 2006-06-07 20:26:10.93 Code: 0x80047076 Source: Data Flow Task DTS.Pipeline Description: The output column "FIELD_28" (3426) on output "Flat File Source Output" (3329) and component "Flat File Source 1" (3328) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. End Warning Error: 2006-06-07 20:26:10.93 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline Description: The product level is insufficient for component "Flat File Source" (1). End Error Error: 2006-06-07 20:26:10.93 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline Description: The product level is insufficient for component "Derived Column" (1452). End Error Error: 2006-06-07 20:26:10.93 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline Description: The product level is insufficient for component "Flat File Source 1" (3328). End Error Error: 2006-06-07 20:26:10.93 Code: 0xC00470FE Source: Data Flow Task DTS.Pipeline Description: The product level is insufficient for component "Derived Column 1" (3429). End Error Warning: 2006-06-07 20:26:10.93 Code: 0x80019002 Source: Package Description: 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. End Warning DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:26:07 PM Finished: 8:26:10 PM Elapsed: 3.422 seconds |
|||||||||||||||||||||||