manibad (1/7/2013)
I will list out the things what i have done.1.In data flow task,OLE DB source->Sort->Data conversion->Excel destination(target is Format.xlsx(template file))
2.In file system task,Source path is Format.xlsx(template) and destination file name is destiny.xlsx.Here the destination file is the copy of template file.
3.Package will be executed in this order Dataflow task->File system task
Note:Format.xlsx was placed after assigning the special formats to the worksheet.
but still i am getting the exported file with general format.I dint get it with special formats.
Now please tell me where i went wrong.So that i will be able to rectify it and proceed without making error.
Pre-requisite: open Format.xlsx (template file) in Excel and apply formatting as needed. Save to disk in original location as original name Format.xlsx.
SSIS Workflow:
1. In file system task, set to Copy source path Format.xlsx (template file) to destination file name is destiny.xlsx (copy of template file). Here the destination file is the copy of template file.
2. In data flow task,OLE DB source->Sort->Data conversion->Excel destination (target is destiny.xlsx (copy of template file))
3. Package will be executed in this order File system task->Dataflow task
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato