Example:
Yesterday's file name "CLM_CLI.789" -- Today's file name "CLM_CLI.6890". Is there any way for SQL2k to delete the file after it is uploaded, or can anyone offer advice about how to use some other method to move the older file to another folder each day??
Thanks!
GlenHow does the DTS package know the name of today's file name?
I think you should be able to use xp_cmdshell to move the file to another directory.
Terri
No comments:
Post a Comment