Installation on Windows Server 2003 x64

Feb 8, 2010 at 5:52 AM

Hello,

First of all, thanks for developing  this component.

I wonder if I can get your advice on getting this to work in my environment.

I've tried two approaches to get this running on a Windows Server 2003 x64 machine running BIDS 2008.

1.) Ran the recommended installer, install was successful but the component does not show up in the Toolbox under SSIS Data Flow Items.

If I open an existing SSIS 2008 package that uses DFS2008 then there is a red cross over the component, the icon switches to XML source and I get an object reference error when I try to view the properties.

2.) Tried the alternate installation method which was to download the DLL, I placed this in the PipelineComponents folder.

 I was able to get component to show up in the toolbox, however when I run a test package I get the below error, thought it might be because the DLL is not registered however if I try to register the DLL with regsvr32 then I get a entry point cannot be found error.

 

Bottom-line is I cannot get things to work in this environment. 

Is DFS 2008 incompatible with my current environment or am I doing something completely daft ?

Cheers.

 

TRACE FROM APPROACH 2

 

Error: 0xC00490F7 at Data Flow Task, Data Flow Task (CSV [1]): The managed pipeline component "DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008Component, DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008, Version=1.0.7.0, Culture=neutral, PublicKeyToken=103567041829a1c2" could not be loaded.  The exception was: Could not load file or assembly 'DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008, Version=1.0.7.0, Culture=neutral, PublicKeyToken=103567041829a1c2' or one of its dependencies. The system cannot find the file specified..
Error: 0xC0047067 at Data Flow Task, Data Flow Task (SSIS.Pipeline): The "component "CSV" (1)" failed to cache the component metadata object and returned error code 0x80131600.
Error: 0xC004706C at Data Flow Task, Data Flow Task (SSIS.Pipeline): Component "component "CSV" (1)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly.
Error: 0xC0048021 at Data Flow Task, Data Flow Task (CSV [1]): The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "www.databasegroup.co.uk".
Error: 0xC004801F at Data Flow Task, Data Flow Task (SSIS.Pipeline): The component metadata for "component "CSV" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
SSIS package "Package.dtsx" starting.
Error: 0xC004801F at Data Flow Task, SSIS.Pipeline: The component metadata for "component "CSV" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0048021 at Data Flow Task, CSV [1]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "www.databasegroup.co.uk".
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "CSV" (1) failed validation and returned error code 0xC0048021.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.

Error: 0xC00490F7 at Data Flow Task, Data Flow Task (CSV [1]): The managed pipeline component "DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008Component, DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008, Version=1.0.7.0, Culture=neutral, PublicKeyToken=103567041829a1c2" could not be loaded.  The exception was: Could not load file or assembly 'DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2008, Version=1.0.7.0, Culture=neutral, PublicKeyToken=103567041829a1c2' or one of its dependencies. The system cannot find the file specified..

Error: 0xC0047067 at Data Flow Task, Data Flow Task (SSIS.Pipeline): The "component "CSV" (1)" failed to cache the component metadata object and returned error code 0x80131600.

Error: 0xC004706C at Data Flow Task, Data Flow Task (SSIS.Pipeline): Component "component "CSV" (1)" could not be created and returned error code 0xC0047067. Make sure that the component is registered correctly.

Error: 0xC0048021 at Data Flow Task, Data Flow Task (CSV [1]): The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "www.databasegroup.co.uk".

Error: 0xC004801F at Data Flow Task, Data Flow Task (SSIS.Pipeline): The component metadata for "component "CSV" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

SSIS package "Package.dtsx" starting.

Error: 0xC004801F at Data Flow Task, SSIS.Pipeline: The component metadata for "component "CSV" (1)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.

Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.

Error: 0xC0048021 at Data Flow Task, CSV [1]: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "www.databasegroup.co.uk".

Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "CSV" (1) failed validation and returned error code 0xC0048021.

Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.