sqlcmd -S CAFRFD1LITPMA02 -i c:\data\export.sql
-o c:\data\text2.txt -s ,
The -i file T-SQL script file must contain all sql script including the bcp logic:
DECLARE @FileName varchar(128),
@BCP varchar(2048)
SET @FileName = REPLACE('c:\data\export\Person'+CONVERT(char(8),GETDATE(),112)+'.txt','/','-')
SET @BCP = 'bcp "SELECT TOP (100) BusinessEntityID, QUOTENAME(FirstName,CHAR(34)), QUOTENAME(LastName,CHAR(34)) FROM AdventureWorks2008.Person.Person ORDER BY LastName" queryout "'
SET @BCP = @BCP + @FileName + '" -c -t, -S "DELLSTAR\SQL2008" -T'
PRINT @BCP
EXEC master.dbo.xp_cmdshell @BCP
The resultant csv file will be what is defined in @FileName for example c:\data\export\Person20090731.txt
bcp "SELECT TOP (100) BusinessEntityID, QUOTENAME(FirstName,CHAR(34)), QUOTENAME(LastName,CHAR(34)) FROM AdventureWorks2008.Person.Person ORDER BY LastName" queryout "c:\data\export\Person20090731.txt" -c -t, -S "DELLSTAR\SQL2008" -T
The c:\data\text2.txt will contain execution messages. You may not need it.
Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012
