jeffwest21
IS-IT--Management
I have a series of files that I am importing into my database, this I can do no problem, my issue is with moving the files afterwards.
I want to move them into a \done\todaysdate folder, again, I can create the folder and three of the four files move into my folder, the fourth doesn't, I am guessing because the file name length is to long.
My issue is trying to rename this file so that it will move, the file will not have a standard name as it has a date created at the end (this is coming from a third party and I cant change it unfortunatly).
How can I get my stored procedure to rename the file using a wild card, the start of the name is always going to the 'servicecdrinformation'
I have tried doing this as part of my batch file that runs the sp, and I have tried the sp itself, but can't seem to get the syntax right, I am almostv finished with this if I can get this bit working.
'Clever boy...'
I want to move them into a \done\todaysdate folder, again, I can create the folder and three of the four files move into my folder, the fourth doesn't, I am guessing because the file name length is to long.
My issue is trying to rename this file so that it will move, the file will not have a standard name as it has a date created at the end (this is coming from a third party and I cant change it unfortunatly).
How can I get my stored procedure to rename the file using a wild card, the start of the name is always going to the 'servicecdrinformation'
I have tried doing this as part of my batch file that runs the sp, and I have tried the sp itself, but can't seem to get the syntax right, I am almostv finished with this if I can get this bit working.
'Clever boy...'
