writing to file using Script task in SSIS 2005 not working

Question

Hi, could anybody give me any clue why this script not doing the job to write the file? in fact when i'm trying to run it on SSIS 2005, the task showed up green and success

I'm confused

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.IO

Public Class ScriptMain
Public Sub Main()

System.IO.File.AppendAllText("e:\test.txt","<![CDATA[ <b>Sales</b>]]>")

Dts.TaskResult = Dts.Results.Success
End Sub

End Class

Thank you in advance

Answer 1

Looks like there is a problem passing in the XML. Try the following and see if that works, if so, then the XML fragment you are adding is the issue.

Public Sub Main()
    Dim strFile As String
    Dim strText As String

    strFile = "e:\test.txt"
    strText = "test"

    Try
        File.AppendAllText(strFile, strText)
    Catch e As Exception
        Dts.TaskResult = Dts.Results.Failure
    End Try
    Dts.TaskResult = Dts.Results.Success


End Sub