ken hanse
asked on
loop for import excel file with date prefix using ssis package
Hi,
I have a requirement to load data into SQL table. The excel files come with the date on it as below format:
xxxxxxx_2015_02_19_050021
Please let me know how do I loop through the files and load the data into a sql table. and also store this files in SQL table
thanks in advance
I have a requirement to load data into SQL table. The excel files come with the date on it as below format:
xxxxxxx_2015_02_19_050021
Please let me know how do I loop through the files and load the data into a sql table. and also store this files in SQL table
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How many files will you process by day?
All files? Only the day file?
All files? Only the day file?
ASKER
Only the day file
Then use the Import Data wizard to create a daily job and assure that the file has always the same name.
ASKER
sorry Vitor, I just need to explained bit more.
the file format is:
xxxxxx_yyyy_mm_dd_mmss
one file per day
This is on excel xls format. I need dynamically read the file,
Thanks
the file format is:
xxxxxx_yyyy_mm_dd_mmss
one file per day
This is on excel xls format. I need dynamically read the file,
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER