(ckirby@mindspring.com) writes:
> Anyone know how to fix this, or an alternative? I did some reading on
> bcp and Bulk Copy, but I couldn't see an easy way to allow for the
> variable path name to the file.

For BCP this is just part of the command line, so it should be problem
to build that command line.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx