Custom Source Component Problem?

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,

Hi Luis,

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
|||

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,

|||Have you tried creating a new empty package and adding a Data Flow and your custom source?

|||

Yes, same thing happens...

This is very very weird...

|||I agree.

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

|||

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 PipelineComponent

I think is pretty normal...

As for the component i sent it by email to you.

Regards,