Larry Brister
asked on
bcp folder path
I'm having some problems with the folder path I've been given
part of the path has a space in it.
Is there a way to handle this or should I have the user rename the folder?
part of the path has a space in it.
Is there a way to handle this or should I have the user rename the folder?
SET @bcpCommand = @bcpCommand + ' \\fileserver\Shares\marketing\media data\dumpfile_' + replace(convert(varchar(10),getdate(),110),'-','') + '.csv -c -t"," -U webPortal -P webP!we%X'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was it...both worked. Thanks
bcp command need double qoutes " " when a select statement is involed
ie
Set @cmd = 'bcp " '+ @outputSQL +' " queryout "' + @CompletedFilePath +'" -T -c -t^,'