Data Flow Task – Excel Destination

Why export data data in excel? Because User wants it in excel. Sometimes I asked myself is there any reason for my work except “satisfying” Users want for excel sheets. From “A1” to final destination . Also, all these sheets should be formatted on right way.

Microsoft didn’t make enough properties for “so loved” Excel Destination in Dataflow Task and I decided to make formatting it on this way:

– create template excel file (saved far away from Users) with Headings and “dummy” row with cell formats

– copy file to desired location and export data into it


 Data Flow to Excel Destination will take the format of last used row for every new row. So, data in W3 cell will be italic with percentage format.  

This entry was posted in SSIS. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s