Archive generated CSV file

Question

Archive generated CSV file

vijay22

Valued Member

Points: 67
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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Paul Ibison SSCertifiable Points: 5303 More actions · Answer 1

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 Valued Member Points: 67 More actions · Answer 2

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 · Answer 3

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 Valued Member Points: 67 More actions · Answer 4

Thanks very much.

I will try this script .

Thanks again very much for me helping me out