Hi,I have developed a custom source component to get data from a generic odbc connection with some special caracteristics.
The component works fine by getting and mapping the output fields etc...
The only two problems existing are that when i run the task it says that the data flow has no components inside... how is this possible since i have my source mapped to a flat file inside that data flow
This is the error:
SSIS package "BVEIT000D.dtsx" starting.
Warning: 0x80047034 at BVEIT000D_<EMPRESA> TXT, DTS.Pipeline: The DataFlow task has no components. Add components or remove the task.
Information: 0x4004300C at BVEIT000D_<EMPRESA> TXT, DTS.Pipeline: Execute phase is beginning.
SSIS package "BVEIT000D.dtsx" finished: Success.
The other problem is that if i want to <ignore> a certain source column the component already shows me an error saying that the no column with ID 0 was found...
Any one with experience in creating custom components
Regards,
Custom Source Component Problem?
Mr B
I might be able to help you but I need some more information. Are you creating the package using the Designer or programatically Do you get an error when adding the component to the data flow
It's hard for me to determine what is going on without seeing the package. Could you post more information about how you're adding the component to the package
Jason
RueSam
Ok this is my attribute settings:
<DtsPipelineComponent(DisplayName:=
"WV ODBC Generic Source", Description:="Data Flow Task that allows you to freely return data based on a SQL Statement against a Generic ODBC Connection", ComponentType:=ComponentType.SourceAdapter, IconResource:="WorldVision.LuisSimoes.SQLServer2005.DataFlow.Sources.WVODBCSource.ico")> Public Class WVODBCSource Inherits PipelineComponentI think is pretty normal...
As for the component i sent it by email to you.
Regards,
wildlife
Yes, same thing happens...
This is very very weird...
Vlasta
Could you post the DtsPipelineComponent attribute settings you are using
It might help to see your actual package too. If you want, you can send it to me at jason.gerard AT idea.com
Henrich
Vladox
Yes i am creating the package using the designer and no error is ocurring... everything works just fine...
I add the component and the file destination i set my component sql to return the fields i map the fields to the file component and then when i run the task it simply says that my data flow doenst have components Jesus...
I hope you can help me here!
Regards,