thank you for the reply....i converted my excel file to .csv....with this it can go through all the files in the folder but it does not copy all the...
can this directly work for excel file instead of converting it to a flat file?
hi, I'm trying to copy one excel file at a time from a folder to sql server using ssis. But this file has different name each week. It is later...
Separate names with a comma.