DTS Import Text file 1

[Eyespi20]

I have created a DTS job to import a text file to my server. The file is named based on the date and time it was put in the folder and I've done a dynamic job to cycle through the names to upload all the files.

My question revolves around marking the file as uplodaded once they are done, otherwise I forsee inserting the same record over and over again.

Can I creat a second dynamic job to rename the file?

Thanks

Margaret

 

[mutley1]

Hi margaret.

You could use xp_cmdshell at the end of your current DTS to rename the file to a .done (or extension of your choice) and in the beginning when you do the import (or determine files to be imported) add a bit in to say ignore .done files.

Rgds,

M.

 

[gradley]

Another option is to use File System Object (FSO) within an ActiveX script to rename or move the files to a different folder.

This examaple adds a "U" prefix to the file name and keeps it in the same folder:

Dim fso 
Dim strFile 
Dim strPath 

Set fso = CreateObject("Scripting.FileSystemObject")
strPath = "c:/PathName/"
fso.MoveFile strPath & "File1.txt", strPath & "U" & "File1.txt"

 

[Eyespi20]

Thanks for the suggestions. THis will work great!

Margaret