I have seen a lot of queries on forums to create an excel file of a particular format and then use it inside a data flow task. File System Task does come to the mind but unfortunately there is no "Create" operation inside File System Task. But there is a workaround with little bit of stage setting. Suppose an excel file is to be created on a daily basis and the name of the file should be the current date (20100110, 20100111 etc.)
First it is required to create a template excel file (same as the file required to be created daily). Then a file system task to copy this template file to the destination folder (folder where the new file is to be created). Then use another file system task to rename the copied file with system date.
Select the 2nd File System Task, hit F4 (to go to its properties) and set "Delay Validation" as TRUE. The new excel file with current date as its name can be verified in folder C:\XYZ
Tags: MSBI, SSIS, file_system_task,
I could move the file but could not rename the file... error points out to invalid format.. could there be anything that i'm missing ???? response is appreciated.
How to i write to
How do i write to the copied excel file from oledb data source