I have tried above thing but I am getting following error:

when I compile my application I get following errors:

Error Code :-1073450910

Sub Component :- Script Component [43]

Description :- System.NullReferenceException: Object reference...

I have added Row Count Component to my package by following code.

Dim DFTransform As IDTSComponentMetaData90

DFTransform = DTP.ComponentMetaDataCollection.New()

DFTransform.ComponentClassID =

"DTSTransform.RowCount"

DFTransform.Name =...

Thanks for reply.

But I have searched a lot but I can't find the way, how to use row number component progammatically and bind it with TaskHost.

Can you please give me...

It worked now.

I was using 64 bit computer and 64 bit computer doesn't register Jet Provider 4.0. So need to run in x86 mode.

This is also giving the same error. Error on AcquireConnection.