xlsx then the next day the file would be file_01022012.xlsx i basically would want to import any. Is there an equivellant tool that works with filemaker pro, on macs ?Ĭan someone show me a sample script to import an excel file if the file were named /users/excel/file_01012012. Here's the issue, i've used ssis/informatic to accomplish these tasks before, including moving the files to archive paths once the process is complete.Īdditionally, the file names will change, so in ssis you can assign variables to the filenames using expressions.
Then move that data into final tables after doing some scrubbingīasically i'm trying to mimic an ETL enviornment. Move the data from files into staging tables
0 kommentar(er)
