J

Thanks for the response.

- yes I can run the select in both verions of SQL

- yes Crystal does allows all types of joins

Any other ideas? All the...

There is a backwards compatibility utiltiy that allows DTS packages to run via a command line utility under SQL Express

Permissions are fine.

The destination for the export is another server and I am using the unc name i.e. \\servername\folder\filename  I changed the destination for the export to the local...