Home All Groups Group Topic Archive Search About

DTEXEC command line error

Author
7 Jun 2006 3:06 PM
JP
Hi

I 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

AddThis Social Bookmark Button