Dtexec 32bit Issue on 64bit server
Hi,i have develop a SSIS package that uses an Excel Source. On the 64bit server (SP3),i use the 32bit dtexec on Program Files (x86) folder.I give you the execution logs. Thanks for your help.
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 16:34:18
Warning: 2009-03-19 16:34:21.46
Code: 0xC0048000
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: The registry key "SOFTWARE\Classes\CLSID\{C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C}\DTSInfo" cannot be opened.
End Warning
Warning: 2009-03-19 16:34:21.46
Code: 0x8004801E
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: Cannot find the "CurrentVersion" value for component {C3BF62C8-7C5C-4F85-83C3-E0B6F6BE267C}. The CurrentVersion value for the component cannot be located. This error occurs if the component has not set its registry information to contain a
CurrentVersion value in the DTSInfo section. This message occurs during component development, or when the component is used in a package, if the component is not registered properly.
End Warning
Warning: 2009-03-19 16:34:21.46
Code: 0xC0048000
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: The registry key "SOFTWARE\Classes\CLSID\{C60ACAD1-9BE8-46B3-87DA-70E59EADEA46}\DTSInfo" cannot be opened.
End Warning
Warning: 2009-03-19 16:34:21.46
Code: 0x8004801E
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: Cannot find the "CurrentVersion" value for component {C60ACAD1-9BE8-46B3-87DA-70E59EADEA46}. The CurrentVersion value for the component cannot be located. This error occurs if the component has not set its registry information to contain a
CurrentVersion value in the DTSInfo section. This message occurs during component development, or when the component is used in a package, if the component is not registered properly.
End Warning
Error: 2009-03-19 16:34:21.46
Code: 0xC0048020
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: The version of component "OLE DB Command" (59) is not compatible with this version of the DataFlow.
End Error
Warning: 2009-03-19 16:34:21.46
Code: 0xC0048000
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: The registry key "SOFTWARE\Classes\CLSID\{B551FCA8-23BD-4719-896F-D8F352A5283C}\DTSInfo" cannot be opened.
End Warning
Warning: 2009-03-19 16:34:21.46
Code: 0x8004801E
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: Cannot find the "CurrentVersion" value for component {B551FCA8-23BD-4719-896F-D8F352A5283C}. The CurrentVersion value for the component cannot be located. This error occurs if the component has not set its registry information to contain a
CurrentVersion value in the DTSInfo section. This message occurs during component development, or when the component is used in a package, if the component is not registered properly.
End Warning
Error: 2009-03-19 16:34:21.46
Code: 0xC0048020
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: The version of component "Excel Source" (1) is not compatible with this version of the DataFlow.
End Error
Error: 2009-03-19 16:34:21.52
Code: 0xC004706C
Source: Data Flow Task DTS.Pipeline
Description: Component "component "Data Conversion" (42)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly.
End Error
Error: 2009-03-19 16:34:21.52
Code: 0xC0048020
Source: Data Flow Task DTS.Pipeline
Description: The version of component "OLE DB Command" (59) is not compatible with this version of the DataFlow.
End Error
March 19th, 2009 6:46pm
It sounds like there is a data flow component that has not being registred correctly. Rafael Salas | Dont forget to mark the post(s) that answered your question
http://rafael-salas.blogspot.com/
Free Windows Admin Tool Kit Click here and download it now
March 22nd, 2009 7:30am
I'm seeing what appears to be the same issue, what is the "data flow component" and how to you register it?
Is this a dll to regsvr or ?
To note, I have the database engine under a 64bit install and SSIS was installed from a 32bit installer (a client did this install).
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.5000.00 for 64-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 12:37:18 PM
Warning: 2011-03-15 12:37:18.71
Code: 0xC0048000
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: The registry key "SOFTWARE\Classes\CLSID\{A1DF9F6D-8EE4-4EF0-BB2
E-D526130D7A7B}\DTSInfo" cannot be opened.
End Warning
Warning: 2011-03-15 12:37:18.71
Code: 0x8004801E
Source: Data Flow Task Data Flow Task (DTS.Pipeline)
Description: Cannot find the "CurrentVersion" value for component {A1DF9F6D-8
EE4-4EF0-BB2E-D526130D7A7B}. The CurrentVersion value for the component cannot b
e located. This error occurs if the component has not set its registry informati
on to contain a CurrentVersion value in the DTSInfo section. This message occurs
during component development, or when the component is used in a package, if th
e component is not registered properly.
End Warning
Error: 2011-03-15 12:37:18.72
Code: 0xC004706C
Source: Data Flow Task DTS.Pipeline
Description: Component "component "Destination - Account_txt" (76)" could not
be created and returned error code 0x80070005. Make sure that the component is
registered correctly.
End Error
Info: 2011-03-15 12:37:18.72
Code: 0x4004300A
Source: Data Flow Task DTS.Pipeline
Description: Validation phase is beginning.
End Info
Progress: 2011-03-15 12:37:18.72
Source: Data Flow Task
Validating: 0% complete
End Progress
Progress: 2011-03-15 12:37:18.74
Source: Data Flow Task
Validating: 50% complete
End Progress
Error: 2011-03-15 12:37:18.74
Code: 0xC0048021
Source: Data Flow Task Destination - Account_txt [76]
Description: The component is missing, not registered, not upgradeable, or mi
ssing required interfaces. The contact information for this component is "Flat F
ile Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft
Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0".
End Error
Error: 2011-03-15 12:37:18.74
Code: 0xC0047017
Source: Data Flow Task DTS.Pipeline
Description: component "Destination - Account_txt" (76) failed validation and
returned error code 0xC0048021.
End Error
Progress: 2011-03-15 12:37:18.74
Source: Data Flow Task
Validating: 100% complete
End Progress
Error: 2011-03-15 12:37:18.74
Code: 0xC004700C
Source: Data Flow Task DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2011-03-15 12:37:18.75
Code: 0xC0024107
Source: Data Flow Task
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 12:37:18 PM
Finished: 12:37:18 PM
Elapsed: 0.547 seconds
March 16th, 2011 9:30pm