Junk Characters Added On Log Files

Hi

We are generating the log file using SSIS built in logging feature. It is generating a text file as "log.txt".

Again we need to add few string values like "Files Loaded Successfully". So i tried adding this string using the following 2 ways.

1. Using Script Task in SSIS

2. Using SQL Stored procedure.

The following are the code:

Through SSIS Script:

Contents = "File Loaded Successfully"

'Get a StreamReader class that can be used to read the file

Dim objStreamWriter As IO.StreamWriter

objStreamWriter =

IO.File.AppendText("\Chnbslsql2k3shareLoglog.txt")

objStreamWriter.Write(Contents)

'Close the stream

objStreamWriter.Close()



Through Stored Proc:

CREATE PROCEDURE [dbo].[LG_Create_LogFile]

AS

BEGIN

SET NOCOUNT ON



DECLARE

@cmdstr as nvarchar(1000),

@Msg AS varchar(1000)



BEGIN TRY

BEGIN

-- Create move command

set @Msg = 'File Loaded by Kumaran '

set @cmdstr = 'echo ' + @Msg + ' >>

\Chnbslsql2k3shareLoglog.txt'





END

-- Execute command

EXEC master..xp_cmdshell @cmdstr

END TRY

BEGIN CATCH

RAISERROR('FILE NOT MOVED SUCCESSFULL', 16, -1)

RETURN -1

END CATCH

END



In the both ways, it is giving me junk characters as like in the below output log.txt file...



PackageStart,CHNBSLSQL2K3,NT AUTHORITYSYSTEM,pkgExtract,{93BE582E-EDDD-4EBD-97A4-8A2E39E839A9},{605B2ED1-D794-4455-BD9E-F32D4CFF1196},9/18/2006 8:43:40 PM,9/18/2006 8:43:40 PM,0,0x,Beginning of package execution.

OnError,,,pkgExtract,,,9/18/2006 8:43:43 PM,9/18/2006 8:43:43 PM,-1071636466,0x,Cannot open the datafile "\Chnbslsql2k3shareRawCPSExtract.dat".

PackageEnd,CHNBSLSQL2K3,NT AUTHORITYSYSTEM,pkgExtract,{93BE582E-EDDD-4EBD-97A4-8A2E39E839A9},{605B2ED1-D794-4455-BD9E-F32D4CFF1196},9/18/2006 8:43:48 PM,9/18/2006 8:43:48 PM,1,0x,End of package execution.

æ¥†æ•¬ä° æ…¯æ•¤?¤ç¥¢ä¬ 浵牡湡€ à¨?





This is a issue which i am struggling and looking on..Please help me out with some gud

solutions.



Thanks

Kumaran