running crystal report from dts using active x component

[Maxie1971]

Hi Guy's

i am trying to create a dts active x component using vb to run an existing crystal report and shell it out into excel...

I am new to doing this and have searched the net to no avail... i don't want to use a third party app to do this...

but i need some idea where to start... does anyone have any example script for doing this?

Thanks in advance.