Archive generated CSV file

• vijay22

  SSC Journeyman

  Points: 77

  More actions

  January 8, 2002 at 4:24 am

  #104863

  I am using DTS to generate a CSV file.

  I want to archive the generated CSV file and genrate a new CSV file every week

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  January 8, 2002 at 5:04 am

  #421882

  Usually manipulating files is done using the file system object in an ActiveX Script in the DTS package, or alternatively in an xp_cmdshell script (which could be done as a step in the scheduled job). Personally I prefer the DTS method as it puts all the code in one place and errors can be trapped more easily (eg the non-existence of the file).

  Paul Ibison

  Paul.Ibison@btinternet.com

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• vijay22

  SSC Journeyman

  Points: 77

  More actions

  January 8, 2002 at 6:23 am

  #421886

  Thanks

  But still i have a problem

  i havent used DTS much so i dont know whats the code to be written

  Can you please help me out .

  Thanks

• Paul Ibison

  SSCertifiable

  Points: 5303

  More actions

  January 8, 2002 at 7:04 am

  #421887

  In a DTS ActiveX script this will rename a file called c:\misc\xxx.txt - try it out.

  Dim fs, sFilePath, sDestinationPath

  Set fs = CreateObject("Scripting.FileSystemObject")

  sFilePath = "c:\misc\xxx.txt"

  sDestinationPath = "c:\misc\yyy.txt"

  If fs.FileExists(sFilePath) Then

  fs.CopyFile sFilePath, sDestinationPath

  fs.DeleteFile sFilePath

  End If

  Set fs = Nothing

  Paul Ibison

  Paul.Ibison@btinternet.com

  
  Paul Ibison
  Paul.Ibison@replicationanswers.com

• vijay22

  SSC Journeyman

  Points: 77

  More actions

  January 8, 2002 at 7:20 am

  #421888

  Thanks very much.

  I will try this script .

  Thanks again very much for me helping me out