s.salikupt
SSC Rookie
Points: 27
More actions
July 3, 2013 at 8:45 pm
#296053
I must create daily report and i must create new excel file each day with SSIS such as
Today = Report1-04/07/2013.xls
Tomorrow = Report0-05/07/2013.xls
do you have a solution?
sorry for my English Skill ^^
Thnank you
Koen Verbeeck
SSC Guru
Points: 259085
July 4, 2013 at 12:49 am
#1629746
You need to create an expression on the Excel connection manager.
You can find an example in this article:
SSIS: How to add a timestamp to a Excel File output path.[/url]
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply