For the below SP, normal text file is getting generated instead of csv file. ALTER PROCEDURE [dbo].[GenerateCDR_Test] AS BEGIN DECLARE @FileName varchar(50), @bcpCommand varchar(2000) SET @FileName = ‘C:\TransactionsData’ + (‘Tansactions_’+ (CONVERT(VARCHAR, GETDATE(), 112) + ‘‘ + CAST(DATEPART(HOUR, GETDATE()) AS VARCHAR) + ‘‘ + CAST(DATEPART(MINUTE,GETDATE()) AS VARCHAR) + ‘_’ + CAST(DATEPART(SECOND, GETDATE()) AS VARCHAR)) + ‘.csv’); […]
- Tags @bcpCommand varchar(2000) SET @FileName = 'C:\TransactionsData' + ('Tansactions_'+ (CONVERT(VARCHAR, 112) + '' + CAST(DATEPART(HOUR, For the below SP, Getdate()) ), GETDATE()) AS VARCHAR) + '_' + CAST(DATEPART(SECOND, GETDATE()) AS VARCHAR) + '' + CAST(DATEPART(MINUTE, GETDATE()) AS VARCHAR)) + '.csv'); SET @bcpCommand = 'BCP '+'"SELECT * FROM [LinkVisaCard].[dbo].[CDRGeneration]"' +' queryout ' SET @bcpCo, normal text file is getting generated instead of csv file. ALTER PROCEDURE [dbo].[GenerateCDR_Test] AS BEGIN DECLARE @FileName varchar(50)