How to split table data into separately named Excel files with 'datepart' using an SSIS package?

Question

I followed this great link below to accomplish 90% of the work. But when I created excel files using 'dateparts' it only created the excel files, but did not load the data into those files.

How to split table data into separate named Excel files using an SSIS package?

Example: This link above showed how to create North, South and Template excel files from table values. But in my case I want to create North_20130613, South_20130613 and template_20130613. I created these files also, but was unable to load the data into them(extended with 'datepart').

I also would like to know how to append everyday data into those files.

HLGEM · Accepted Answer · 2013-09-03 15:03:27Z

0

Usually I load the data into the file with the general name and then rename the file with the datapart afterwards.

answered Sep 3, 2013 at 15:03

HLGEM

97k15 gold badges120 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to split table data into separately named Excel files with 'datepart' using an SSIS package?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related