How to create a Dynamic SSIS package to generate muliptle weekly flat files
Hi I got a requirement that I should create SSIS package which when runs generates weekly flat files for the months July and August , i mean totally there are 8 weeks from july 1 to august 25, so thee package should generate 8 flat files once I run this SSIS package. I am using SQL Server 2005. Thank You
You can achieve this by processing the data in a loop. First you get a list of months you need to process. then in the For Each Loop you put the data flow, which will process the data for single particular month and write those data to a flat file. The Flat File destination will be configured in a way, that it will use an expression for the file name, where the name for particular month will be constructed.