Changing the SQL Statement of a Transformation from VB

[Adrian Bennett]

Hi

I need to be able to change the SQL Statement of a data transformation from
within a VB executable. I'm using the DTS Package to create a CSV file from
a SQLServer table. I can change the name of the CSV export file from VB. I
want to be able to pass back a parameter to the SQL statement in the
transformation. I can't figure out how to do this so any help will be
appreciated.

Thanks
Adrian