Could somebody help with coding in SQL to perform the following...
check folder - \\cluster\data\Direxxis\Erie\incoming\
if there is a matrix file – eg. Erie_Creative_Matrix_20140403.xlsx
remove the date portion eg. _20140403
copy matrix file without the date portion to \\cluster\data\Direxxis\Erie\incoming\
- but before changing the file name copy the original eg. Erie_Creative_Matrix_20140403.xlsx to
run dtsx (with new file name eg. Erie_creative_Matrix.xslx)
Thanks in Advance