I can make the BULK INSERT work with no problems. I need a way to bulk
EXPORT data from a table to the server in a specified folder.

What is the best way to do this? It has to be dynamic. The FROM table and
the TO file name are supplied as parameters to whatever process ends up
being the tool.

Thanks!
Richard

Hello Richard,

You could use bcp to do this and build the cmd string dynamagically. If
you are using DTS then you could use the ExecuteProcess task to do this.

See if this article gives you any ideas

http://www.sqldts.com/default.aspx?251


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com