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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics