This sample allows you to create a package from a variety of data sources and destinations. It creates a simple package that you can create from an SQL statement or a Microsoft® ActiveX® script. You can choose a data source and destination from an enumerated list.
C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\Dts\Dtspackages\dtsexmp3
Open and run dtsqry.vbp.