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

image

 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.  

Advertisements
This entry was posted in SSIS. Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s