I solved the poblem by creating a table, then scheduling a job that populates the table through using the stored proc.  I then just use the table directly in DTS.

F.