0

I am currently generating the excel files dynamically using foreach loop+file system task+ data flow task which will load data to the excel files. But, when i am getting duplicate records instead of over writing already created excel file. I want the duplicate records to load into already created file. For example if for one product there are four prod items having same name. The file created with a specific product should have all the product items in it.

Please suggest me a solution. Since this is excel generation which is most hectic thing in ssis.. please try to provide soln elaborately. Thanks in advance.

VRaju
  • 21
  • 1
  • 8
  • From what I have seen, over-writing is not the default behavior of the Excel connection manager, so I do not know how you are getting this result. You will need describe your problem in more detail. – Tab Alleman Mar 28 '16 at 13:08

1 Answers1

0

Use a script task to see if the file exists. If it does, delete the file and regenerate.

Here are examples:

Community
  • 1
  • 1
Stephen Lloyd
  • 733
  • 8
  • 21