I'm running these:

set @sql='exec master..xp_cmdshell ''bcp " select * from (select '+@columns+') as t" queryout "'+ @filePath + @file_name+'" -w -t";" -T '''

exec(@sql)

set @sql='exec master..xp_cmdshell ''bcp " select ' + @columns1 + ' from '+@db_name+'..'+@TableName+' where statusflag = 0 and reps >= '+ @StartRep + ' and reps <= ' + @EndRep + ' " queryout "' + @data_file+'" -w -t";" -T '''

--print @sql

exec(@sql)

When I run your code, I get this error:

I'm going to check those books out, for sure.

Thanks