Add version number to XML file using VB

• SatishAyyar

  SSCrazy

  Points: 2825

  More actions

  October 11, 2010 at 9:09 am

  #72943

  I generated a xml file for a data in SSIS using script task (VB script), but the version tag line is missing in the xml file. Can you please help me out.

  The VB code i used in script task is below

  Public Sub Main()

  '

  Dim sw As New IO.StreamWriter(Dts.Variables("User::FilePath").Value.ToString() + Dts.Variables("User::FileName").Value.ToString() + "_1.XML")

  sw.Write(Dts.Variables("User::Content").Value.ToString())

  sw.Dispose()

  '

  Dts.TaskResult = ScriptResults.Success

  End Sub

  Thanks in advance

• Russel Loski

  SSCertifiable

  Points: 7058

  More actions

  October 12, 2010 at 4:50 pm

  #1235927

  Where does the variable "User::Content" get populated? Maybe there is where the version number needs to be added.

  Russel Loski, MCSE Business Intelligence, Data Platform