The component could not be added to Dat Flow task

Jan 21, 2010 at 12:57 PM

After installing on machine with sql server 2005 and both Visual Studio 2005 and 2008, when try to drag the DFS 2005 component onto the data flow pane, get error

The component could not be added to the Data Flow task.
Please verify that this component is properly installed.


The data flow object "DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2005Component, DatabaseGroup.SSIS.SourceAdapters.DelimitedFileSource2005, Version=, Culture=neutral, PublicKeyToken=103567041829a1c2" is not installed correctly on this computer. (Microsoft.DataTransformationServices.Design)

Any ideas on fix.

Also, i'm going to need to put this on an SQL Server 2000 only machine and run through SSIS runtime. BUT the installer requires .NET 3.5 runtime  to install (though is targeted at .NET runtime 2.0)

I won't be allowed to install .NET 3.5 installer. Is there a manual install (assuming i can get round the problems above) ???

Jul 15, 2010 at 7:30 AM

i restarted ssis service. it worked. At least it seemed. Then I found it did not pull any columns