Thanks.

I was looking for something like a popup window with a button. So the SSIS package waits for the button to be pushed before it proceeds.

It doesn't take SQL functions in the expression builder, does it?

Thanks,

I was thinking about creating a clustered index on an idenitity column, but then I decided to export the table from a query. I guess it's the quickest and easiest...

Jeff,

I am using the Export Wizard.

Thanks

thanks Tim for your help,

I had to talk with DBAs and had one drive mapped to the same folder.